INTEGER

You can abbreviate INTEGER to INT. Without the EXTERNAL specification, this data type description indicates a four-byte internal integer value. For more information about these options, see Additional-numeric-fields-considerations.

INTEGER EXTERNAL

INTEGER EXTERNAL indicates a string that contains a character representation of a number.

(length,scale)

Length, if specified, must be 4. You can specify scale with or without specifying a length. Specifying scale multiplies or divides the number by a power of 10.

LOADPLUS does not support the scale specification if you are converting to a DECFLOAT column.

ROUND

ROUND tells LOADPLUS to round the value, if necessary, during conversion. If you do not specify ROUND, LOADPLUS truncates any digits that are not needed for precision.

REMOVESIGN

When you are converting to a CHAR or VARCHAR column, REMOVESIGN tells LOADPLUS not to include a sign in the values that it loads. When you specify this option, LOADPLUS does not reserve a byte at the beginning of the column for a sign.