JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

SQL/MX Data TypeSupported by JDBC/MXJDBC Data Type
NoTypes.REF
SMALLINTYesTypes.SMALLINT
NoTypes.STRUCT
TIMEYesTypes.TIME
TIMESTAMPYesTypes.TIMESTAMP
NoTypes.TINYINT
NoTypes.VARBINARY
VARCHAR(n)YesTypes.VARCHAR
* See “Floating-Point Support” (page 72).
** For details about maximum length, see the SQL/MX Reference Manual.
The JDBC/MX driver maps the following SQL/MX data types to the JDBC data type Types.OTHER:
DATETIME YEAR
DATETIME YEAR TO MONTH
DATETIME YEAR TO DAY
DATETIME YEAR TO HOUR
DATETIME YEAR TO MINUTE
DATETIME MONTH
DATETIME MONTH TO DAY
DATETIME MONTH TO HOUR
DATETIME MONTH TO SECOND
DATETIME DAY
DATETIME DAY TO HOUR
DATETIME DAY TO MINUTE
DATETIME DAY TO SECOND
DATETIME HOUR
DATETIME HOUR TO MINUTE
DATETIME MINUTE
DATETIME MINUTE TO SECOND
DATETIME SECOND
DATETIME FRACTION
INTERVAL YEAR(p)
INTERVAL YEAR(p) TO MONTH
INTERVAL MONTH(p)
INTERVAL DAY(p)
INTERVAL DAY(p) TO HOUR
INTERVAL DAY(p) TO MINUTE
INTERVAL DAY(p) TO SECOND
INTERVAL HOUR(p)
INTERVAL HOUR(p) TO MINUTE
INTERVAL HOUR(p) TO SECOND
INTERVAL MINUTE(p)
INTERVAL MINUTE(p) TO SECOND
INTERVAL SECOND(p
Floating-Point Support
The JDBC/MX driver and the NonStop Server for Java pass any FLOAT (32-bit) number or DOUBLE
(64-bit) number in the IEEE 754 floating-point format.
Floating-point values are stored in SQL/MX tables as IEEE 754 values.
Floating-point values are stored in SQL/MP tables in Tandem format (also referred to as the TNS
format). For floating-point values stored in SQL/MP tables in the Tandem format, SQL/MX performs
72 JDBC/MX Compliance