Skip to Content

INTEGER

This keyword defines an integer numeric field.

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

Related topic

Data type keywords

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.

 

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

UNLOAD PLUS for DB2 13.1