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 |