JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

SQL/MP Data TypeSQL/MX Data Type
DATETIME MONTH TO HOURINTERVAL DAY(p) TO SECOND
DATETIME MONTH TO SECONDINTERVAL HOUR(p)
DATETIME DAYINTERVAL HOUR(p) TO MINUTE
DATETIME DAY TO HOURINTERVAL HOUR(p) TO SECOND
DATETIME DAY TO MINUTEINTERVAL MINUTE(p)
DATETIME DAY TO SECONDINTERVAL MINUTE(p) TO SECOND
DATETIME HOURINTERVAL SECOND(p)
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” (page 79)
• “Unsupported SQL/MP Features” (page 80)
Unsupported SQL/MX Features
• MXCI commands
• SQL/MX utility commands
• SQL Statements
Transaction Control statements◦
◦ Resource control and optimization statements
◦ Object naming statements
◦ Alias statements
Refer to the NonStop SQL/MX documentation set for a complete list of supported features.
Floating-Point Support 79