DECIMAL
DECIMAL defines a decimal field.
You can abbreviate DECIMAL to DEC. DECIMAL without an additional keyword functions the same as DECIMAL PACKED. For more information about these options, see Additional-numeric-fields-considerations.
DECIMAL PACKED
DECIMAL PACKED, which is the default, indicates that the input value is packed decimal.
DECIMAL ZONED
DECIMAL ZONED indicates that the input value is zoned decimal.
DECIMAL EXTERNAL
DECIMAL EXTERNAL indicates a string that contains a character representation of a number. If the value includes a decimal point, LOADPLUS ignores any scale specification.
(length,scale)
You can specify one or both of these options. Length (or precision) is the total number of digits. Specifying scale multiplies or divides the number by a power of 10. For more information about scale, see Scale.
ROUND
ROUND tells LOADPLUS to round the value, if necessary, during conversion. If you do not specify ROUND, LOADPLUS truncates any digits that are not needed for precision.
REMOVEDECIMAL
When you are converting to a CHAR or VARCHAR column, REMOVEDECIMAL tells LOADPLUS to remove the fractional portion, including the decimal point, of the value that it loads. LOADPLUS performs this function after performing any scale or rounding functions.
REMOVESIGN
When you are converting to a CHAR or VARCHAR column, REMOVESIGN tells LOADPLUS not to include a sign in the values that it loads. When you specify this option, LOADPLUS does not reserve a byte at the beginning of the column for a sign.
Related topic