src.com.ibm.as400.access.doc-files.SQLTypes.html Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of jt400-jdk9 Show documentation
Show all versions of jt400-jdk9 Show documentation
The Open Source version of the IBM Toolbox for Java
IBM Toolbox for Java: JDBC SQL Types
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.