JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Types.VARCHAR
Yes VARCHAR(n)
Types.BOOLEAN
Data type is mapped by SQL/MX . Data type varies from that used for table creation. CHAR(1)
Types.DATALINK
No N.A.
¹ Because of mapping provided by SQL/MX, a
ResultSet.getObject() method returns a string object instead of an array of bytes.
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
DATETIME SECOND
DATETIME FRACTION
Floating-Point Support
The Type 4 driver supports only IEEE floating-point data to be passed between the application client and the Type 4 driver.
Note: Any data access to or from a column with Tandem floating-point format in SQL/MP, might result in loss of precision
of the data.
JDBC Type 4 Driver Features
The JDBC Type 4 driver supports the following features:
Row size limit is increased to align with maximum block size 32768 for MX tables.
A clustering key length up to 2048 bytes is allowed for range and hash partitioned MX tables.
The precision of the NUMERIC data type is extended up to 128 digits for signed and unsigned values.
Unsupported NonStop SQL Features
Unsupported SQL/MX Features
Unsupported SQL/MP Features