Db2 for z/OS data type support and correspondence
Db2 type | TQL type | notes |
|---|---|---|
BIGINT | java.lang.Long | |
BINARY | java.lang.Object | |
BLOB | java.lang.Object | |
CHAR | java.lang.String | |
CLOB | java.lang.String | |
DATE | java.time.LocalDate | |
DBCLOB | java.lang.String | |
DECFLOAT | java.math.BigDecimal | |
DECIMAL | java.math.BigDecimal | |
DOUBLE | java.lang.Double | |
FLOAT | java.lang.Double | |
GRAPHIC | java.lang.String | |
INTEGER | java.lang.Integer | |
NUMERIC | java.math.BigDecimal | |
REAL | java.lang.Double | |
ROWID | java.lang.Object | |
SMALLINT | java.lang.Short | |
TIME | java.time.LocalTime | |
TIMESTAMP | java.time.LocalDateTime | If ReturnDateTimeAs is String, the timestamp will be in the format YYYY-MM-DD HH:mm:ss.sss. |
TIMESTAMP WITH TIME ZONE | java.time.ZonedDateTime | If ReturnDateTimeAs is String, the timestamp will be in the format YYYY-MM-DD HH:mm:ss.sss. |
VARBINARY | java.lang.Object | |
VARCHAR | java.lang.String | |
VARGRAPHIC | java.lang.String | |
XML | java.lang.String |