DECIMAL

This keyword defines a decimal numeric field. You can abbreviate DECIMAL to DEC. 

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:
  • 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.

Related topics

BMC-AMI-Unload-field-specification

SELECT-statement-options

BMC AMI Unload option descriptions

UNLOAD-syntax-diagrams 

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.

FILL

FILL tells BMC AMI Unload how to handle leading zeros when converting data to DECIMAL EXTERNAL. Specify YES or NO:

  • FILL YES externalizes all leading zeros when converting numeric data types to their external representations. The first character in the external representation of the number is either a minus sign (-) or a plus sign (+). This capability supports applications such as COBOL that require leading zeros in order to edit and check unloaded data properly.
  • FILL NO removes all leading zeros when converting numeric data types to their external representations.



 

  • 13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*