SMALLINT

SMALLINT defines a small integer numeric field.

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

Related topic

Data-type-keywords

SMALLINT(length, scale)

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

SMALLINT 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 SMALLINT. 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 SMALLINT 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*