Item type properties
The following table lists the DB2® (Windows/UNIX) data types and the values of the item type properties to which they correspond when the type tree is generated.
| DB2 Data Type | Interpret as | Item Subclass, Presentation | Length |
|---|---|---|---|
| INTEGER | Character | Number, Integer | 11 |
| SMALLINT | Character | Number, Integer | 6 |
| FLOAT | Binary | Number, Float | 8 |
| REAL | Binary | Number, Float | 4 |
| DOUBLE PRECISION | Binary | Number, Float | 8 |
| DECIMAL(n)1 | Character | Number, Integer | * |
| DECIMAL(n,m)2 | Character | Number, Decimal | * |
| NUMERIC(n)1 | Character | Number, Integer | * |
| NUMERIC(n,m)2 | Character | Number, Decimal | * |
| CHAR | Character | Text | * |
| VARCHAR | Character | Text | * |
| DATE | Character | Date & Time | 10 |
| TIME | Character | Date & Time | 8 |
| TIMESTAMP | Character | Date & Time | 26 |
| GRAPHIC | Binary | Text | * |
| VARGRAPHIC | Binary | Text | * |
| BLOB | Binary | Text | * |
| CLOB | Character | Text | * |
| DBCLOB | Character | Text | * |
1 n > 1
2 n > 1, m > 0
* The DBMS dictates the length of this type.
Note: The
BLOB, CLOB and DBCLOB data types are not supported as parameters for
stored procedures.