How DB2 data types convert to item types in a type tree
The following table lists the DB2® (z/OS® ODBC) data types and the values of the item type properties to which they correspond when a type tree is generated by the Database Interface Designer and mtsmaker. An asterisk (*) in the Length column indicates that the DBMS dictates the length of this type.
| DB2 (z/OS ODBC) Data Type | Interpret as | Item Subclass, Presentation | Length |
|---|---|---|---|
| SQL_VARCHAR | Character | Text | * |
| SQL_CHAR | Character | Text | * |
| SQL_DECIMAL | Character | Number, Decimal | 17 |
| SQL_NUMERIC | Character | Number, Decimal | 17 |
| SQL_SMALLINT | Character | Number, Integer | 6 |
| SQL_INTEGER | Character | Number, Integer | 11 |
| SQL_REAL | Binary | Number, Float | 4 |
| SQL_FLOAT | Binary | Number, Float | 8 |
| SQL_DOUBLE | Binary | Number, Float | 8 |
| SQL_LONGVARCHAR | Character | Text | * |
| SQL_BIT | Character | Number, Integer | * |
| SQL_TINYINT | Character | Number, Integer | 4 |
| SQL_BIGINT | Character | Number, Integer | 20 |
| SQL_BINARY | Binary | Text | * |
| SQL_VARBINARY | Binary | Text | * |
| SQL_LONGVARBINARY | Binary | Text | * |
| SQL_DATE | Character | Date & Time | 10 |
| SQL_TIME | Character | Date & Time | 8 |
| SQL_TIMESTAMP | Character | Date & Time | 19-26 |
| SQL_INTERVAL_HOUR | Character | Text | * |
| SQL_INTERVAL_MINUTE | Character | Text | * |
| SQL_INTERVAL_SECOND | Character | Text | * |
| SQL_INTERVAL_YEAR_TO_MONTH | Character | Text | * |
| SQL_INTERVAL_DAY_TO_HOUR | Character | Text | * |
| SQL_INTERVAL_DAY_TO_MINUTE | Character | Text | * |
| SQL_INTERVAL_DAY_TO_SECOND | Character | Text | * |
| SQL_INTERVAL_HOUR_TO_MINUTE | Character | Text | * |
| SQL_INTERVAL_HOUR_TO_SECOND | Character | Text | * |
| SQL_INTERVAL_MINUTE_TO_SECOND | Character | Text | * |
| SQL_BLOB | Binary | Text | * |
| SQL_CLOB | Character | Text | * |
| SQL_DBCLOB | Character | Text | * |
Note: The SQL_BLOB, SQL_CLOB and SQL_DBCLOB data types are not supported as parameters for stored
procedures.