JDBC SQL Types

Unsupported SQL Types

Not all of the SQL types described by the JDBC specification are supported by DB2 for i5/OS. In the cases where a SQL type is not supported, the JDBC driver substitutes a similar SQL type.

The following table lists the SQL types that are not supported and the SQL type that JDBC driver substitutes for each.

Unsupported SQL type Substituted SQL type
BIT SMALLINT
TINYINT SMALLINT
BIGINT (on OS/400 Version 4 Release 4 and previous) INTEGER
LONGVARCHAR VARCHAR
LONGVARBINARY VARBINARY

Note: BIGINT is supported on OS/400 V4R5 and later.