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.