DECIMAL

The following considerations apply to decimal field data types:

• When converting from a numeric column, the default precision for these fields is based on the source data type:
  • SMALLINT-for-BMC-AMI-Unload—5
  • INTEGER—11
  • BIGINT-for-BMC-AMI-Unload—19
  • DECFLOAT-for-BMC-AMI-Unload—31
  • All other data types—15
• When converting from a character column:
  • The source value can contain leading or trailing blanks.
  • Precision must be less than scale and scale cannot be greater than 31.
  • If the string contains a decimal point, BMC AMI Unload converts the string based on that decimal point, then scales to the specified scale.

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.