Open System Services ODBC/MX Client Driver (SQL/MX 3.x)

ODBC/MX Conformance
HP NonStop Open System Services ODBC/MX Client Driver—640328-001
3-13
Microsoft Escape Clauses
Microsoft Escape Clauses
ODBC/MX accepts Microsoft escape clauses and translates them into equivalent
SQL/MX clauses.
DATETIME MINUTE TO FRACTION SQL_TIMESTAMP
DATETIME SECOND SQL_TIME
DATETIME SECOND TO FRACTION SQL_TIMESTAMP
Table 3-18. Microsoft Escape Clauses
Microsoft Escape Clause SQL/MX Equivalent
{ d 'date-literal' } DATE 'date-literal'
{ t 'time-literal' } TIME 'time-literal'
{ ts 'timestamp-literal' } TIMESTAMP 'timestamp-literal'
1
{ oj join-expression } join-expression
{ INTERVAL sign
interval-string
interval-qualifier }
INTERVAL sign
interval-string
interval-qualifier
{ fn scalar-function } scalar-function
2
{ call
procedure-name... }
Supported in current release
{ escape 'escape-character' } Not supported in the current release.
{ [?=]call
procedure-name... }
Not supported in the current release.
1. ODBC syntax does not include nested joins, while SQL/MX does. ODBC/MX extends the Microsoft syntax for
an outer join.
2. Functions are controlled by SQLGetInfo. Only SQL/MX native functions are supported.
Table 3-17. SQL/MP to ODBC/MX Date/Time Mappings
SQL/MP Data Type ODBC/MX Data Type Returned