JDBC Type 4 Driver Programmer's Reference

Types.CHAR
Yes CHAR(n)
Types.CLOB
No N.A.
Types.DATE
Yes DATE
Types.DECIMAL
Yes DECIMAL(p,s)
Types.DISTINCT
No N.A.
Types.DOUBLE
Yes
DOUBLE
PRECISION
Types.FLOAT
Yes FLOAT(p)
Types.INTEGER
Yes INTEGER
Types.JAVA_OBJECT
No N.A.
Types.LONGVARBINARY
Data type is mapped by SQL/MX 2.0.
Data type varies from that used for
table creation.
VARCHAR(n)
Types.LONGVARCHAR
Yes
Maximum length is 4018
VARCHAR[(n)]
Types.NULL
No N.A.
Types.NUMERIC
Yes NUMERIC(p,s)
Types.REAL
Yes FLOAT(p)
Types.REF
No N.A.
Types.SMALLINT
Yes SMALLINT
Types.STRUCT
No N.A.
Types.TIME
Yes TIME
Types.TIMESTAMP
Yes TIMESTAMP
Types.TINYINT
Data type is mapped by SQL/MX 2.0.
Data type varies from that used for
table creation.
SMALLINT
Types.VARBINARY
Data type is mapped by SQL/MX 2.0.
Data type varies from that used for
table creation.
VARCHAR(n)
Types.VARCHAR
Yes VARCHAR(n)
Types.BOOLEAN
Data type is mapped by SQL/MX 2.0.
Data type varies from that used for
table creation.
CHAR(1)
Types.DATALINK
No N.A.
The Type 4 driver maps the following data types to the JDBC data type Types.OTHER:
SQL/MX Data Type SQL/MP Data Type
INTERVAL YEAR(p) DATETIME YEAR
INTERVAL YEAR(p) TO MONTH DATETIME YEAR TO MONTH
INTERVAL MONTH(p) DATETIME YEAR TO HOUR
INTERVAL DAY(p) DATETIME YEAR TO MINUTE
INTERVAL DAY(p) TO HOUR DATETIME MONTH
INTERVAL DAY(p) TO MINUTE DATETIME MONTH TO DAY
INTERVAL DAY(p) TO SECOND DATETIME MONTH TO HOUR
INTERVAL HOUR(p) DATETIME MONTH TO SECOND
INTERVAL HOUR(p) TO MINUTE DATETIME DAY
INTERVAL HOUR(p) TO SECOND DATETIME DAY TO HOUR
INTERVAL MINUTE(p) DATETIME DAY TO MINUTE
INTERVAL MINUTE(p) TO SECOND DATETIME DAY TO SECOND
INTERVAL SECOND(p) DATETIME HOUR
DATETIME HOUR TO MINUTE
DATETIME MINUTE
DATETIME MINUTE TO SECOND