Convert Between Numeric Types

You can convert data from one numeric type to another. Errors can occur if the new type is an exact numeric with precision or scale that is insufficient to hold the data.

For example, if you provide a float or numeric value as an argument to a built-in function that expects an integer, the value of the float or numeric is truncated. However, SAP ASE does not implicitly convert numerics that have a fractional part but return a scale error message. For example, SAP ASE returns error 241 for numerics that have a fractional part and error 257 if other datatypes are passed.

Use the arithabort and arithignore options to determine how SAP ASE handles errors resulting from numeric conversions.