DECIMAL
DECIMAL PACKED (precision, scale)
DECIMAL PACKED is the default, which indicates that the output value is packed decimal with precision and scale. The precision represents the total number of digits; the scale represents the number of digits in the fractional part of the number.
DECIMAL (precision, scale)
This option is identical to DECIMAL PACKED.
DECIMAL ZONED (precision, scale)
This option specifies that the output value is decimal-zoned with precision and scale. The precision represents the total number of digits; the scale represents the number of digits in the fractional part of the number.
DECIMAL EXTERNAL (length, scale)
EXTERNAL indicates a string that contains a character representation of a decimal constant. A decimal point is always placed in the string based on the scale specification. For more information, see Additional numeric EXTERNAL or CHARACTER field considerations.
ROUND | ROUND tells UNLOAD PLUS to round the value, if necessary, during conversion. If you do not specify ROUND, UNLOAD PLUS truncates any digits that it does not need for precision. |
|---|---|
FILL | FILL tells UNLOAD PLUS how to handle leading zeros when converting data to DECIMAL EXTERNAL. Specify YES or NO:
|