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|
|BIGINT (on OS/400 Version 4 Release 4 and previous)||INTEGER|
Note: BIGINT is supported on OS/400 V4R5 and later.