4. Elements of QUEL Statements : Operations : Assignment : Numeric
 
Share this page                  
Numeric
You can assign any numeric data type to any other numeric data type. You can assign a money value to any numeric data type and a numeric value to the money data type. Numeric assignments have the following characteristics:
The DBMS Server can truncate leading zeros or all or part of the fractional part of a number if necessary. If the non-fractional part of a value (other than leading zeros) is truncated, an overflow error results. (These errors are reported only if the -numeric_overflow flag is set. For information about the -numeric_overflow flag, see the quel command description in the Command Reference Guide.)
When a float, float4, or money value is assigned to an integer column or variable, the fractional part is truncated.