MX 2.x)

{ 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.

HP JDBC/MX 5.0 Driver for SQL/MX Programmer's Reference (540388-006)