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.

BIGINT

BIGINT defines a big integer numeric field.

For more information, see Additional-numeric-field-considerations.

BIGINT(length, scale)

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

BIGINT EXTERNAL(length, scale)

EXTERNAL indicates a string that contains a character representation of an integer constant. This data type is identical to INTEGER EXTERNAL except that when you use CNTLCARDS Db2 or CNTLCARDS DB2DDL, the CREATE TABLE column type is BIGINT. 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 BIGINT 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*