JDBC SQL Types

Unsupported SQL Types

Not all of the SQL types described by the JDBC specification are supported by DB2 for OS/400. 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 subtitutes for each.
Unsupported SQL type Substituted SQL type
BIT SMALLINT
TINYINT SMALLINT
BIGINT INTEGER
LONGVARCHAR VARCHAR
LONGVARBINARY VARBINARY