JDBC Driver for SQL/MX Programmer's Reference

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.

HP JDBC Driver for SQL/MX Programmer's Reference (529777-001)