Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

INTEGER

This keyword defines an integer numeric field.

You can abbreviate INTEGER to INT. For more information, see Additional-numeric-field-considerations.

INTEGER(length, scale)

INTEGER indicates an internal 4-byte integer value. If you specify the length, you must specify 4. Specifying scale multiplies or divides the number by a power of 10.

INTEGER EXTERNAL(length, scale)

EXTERNAL indicates a string that contains a character representation of an integer constant. 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 INTEGER 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.

Related topic

Data-type-keywords

 

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