Replication
IBM DB2/AS400 Data Type Definitions
The following table lists the IBM DB2/AS400 data type definitions.
| DB2/AS400 data type | Definition |
|---|---|
| INT | 9 |
| SMALLINT | 4 |
| FLOAT | <=53 |
| NUMERIC | 1 - 31 digits |
| DECIMAL | 1 - 31 digits |
| CHAR | <=32766 |
| VARCHAR | <=32740 |
| LONG VARCHAR | Determined by space available in row |
| TIMESTAMP | Gregorian |
| GRAPHIC | <=16383 |
| VARGRAPHIC | <=16370 |
| LONG VARGRAPHIC | Determined by space available in row |
| REAL | 8,7 |
| DOUBLE | 17,16 |