JDBC Type 4 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

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
Unsupported SQL/MX Features
MXCI commands●
SQL/MX utility commands●
SQL Statements
Transaction Control statements
❍
Prepared SQL statements (PREPARE and EXECUTE)❍
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.
Unsupported SQL/MP Features
SQL/MP DDL support●
Columns described with the character sets ISO8859/2 through ISO8859/9●
Utility commands●
Embedded-only SQL/MP statements●
Transaction Control statements●
Stored procedures●