The numeric data types can be defined in all host languages.
All binary integers and decimal numbers have a sign and a precision. The precision is the total number of binary or decimal digits, excluding the sign.
A zoned decimal number with an implicit decimal point. The position of the decimal point determined by the precision and scale of the number.
The precision is the total number of decimal digits. The maximum precision is 31 digits.
The scale is the number of digits in the fractional part of the number. The scale cannot be negative and it cannot be greater than the precision.
All values of a decimal column have the same precision and scale. The range of a decimal variable or the numbers in a decimal column is -n to n. The absolute value of n is the largest number that can be represented with the applicable precision and scale.
A packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and scale of the number.
The precision is the total number of decimal digits. The maximum precision is 31 digits.
The scale is the number of digits in the fractional part of the number. The scale cannot be negative and it cannot be greater than the precision.
All values of a decimal column have the same precision and scale. The range of a decimal variable or the numbers in a decimal column is -n to n. The absolute value of n is the largest number that can be represented with the applicable precision and scale.
A binary integer with a precision of 15 bits. The range of small integers is -32768 to 32767.
A binary integer with a precision of 31 bits. The range of large integers is -2147483648 to 2147483647.
A long (64 bits) floating-point number. The range of magnitudes is approximately 5.4E-79 to 7.2E+75.
A long (64 bits) floating-point number. The range of magnitudes is approximately 5.4E-79 to 7.2E+75.
A long (64 bits) floating-point number. The range of magnitudes is approximately 5.4E-79 to 7.2E+75.
|
Copyright © 2014 CA.
All rights reserved.
|
|