The numeric types are as follows:
- BIGINT refers to an 8-byte area that stores an integer of as many as 18
digits.
- BIN refers to a binary number.
- DECIMAL refers to packed decimal characters whose sign is represented
by a hexadecimal C (for a positive number) or a hexadecimal D (for a negative
number) in the right half of the rightmost byte.
- FLOAT refers to an 8-byte area that stores a double-precision floating-point
numbers with up to 16 significant digits.
- INT refers to a 4-byte area that stores an integer of as many as 9 digits.
- MONEY refers to currency amounts, which are stored as DECIMAL values.
- NUM refers to numeric characters whose sign is represented by a sign-specific
hexadecimal value in the left half of the rightmost byte (EBCDIC D for negative).
- NUMC refers to numeric characters whose sign is represented by a sign-specific
hexadecimal value in the left half of the rightmost byte (EBCDIC C for negative).
- PACF refers to packed decimal characters whose sign is represented by
a hexadecimal F (for a positive number) or a hexadecimal D (for a negative
number) in the right half of the rightmost byte.
- SMALLFLOAT refers to a 4-byte area that stores a single-precision floating-point
number with up to 8 significant digits.
- SMALLINT refers to an 2-byte area that stores an integer of as many as
4 digits.
Refer to the subtopics under this heading for more information on this
subject.