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

see "Data Types" in the

SQL/MX Reference Manual

SQL Escape Clauses

JDBC/MX accepts SQL escape clauses and translates them into equivalent SQL/MX clauses, as shown in the

following table:

SQL Escape Clause SQL/MX Equivalent Clause

{ d 'date-literal' } DATE 'date-literal'

{ t 'time-literal' } TIME 'time-literal'

{ ts 'timestamp-literal' } TIMESTAMP 'timestamp-literal'

{ oj join-expression } join-expression *

{ INTERVAL sign

interval-string

interval-qualifier }

INTERVAL sign

interval-string

interval-qualifier

{ fn scalar-function } scalar-function

{ escape 'escape-character' } escape 'escape-character'

{ call procedure-name... } CALL procedure-name...

{ ?=call procedure-name... }

Not supported in the current

release

* JDBC syntax does not include nested joins, while SQL/MX does.

JDBC/MX extends the SQL escape syntax for an outer join.

JDBC/MX Type 2 Driver Features

The JDBC/MX Type 2 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.

HP NonStop JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.1 (663859-001)