Hp Integrity NonStop H-Series Manual de usuario descargar pdf (Pagina 41)

Table 8 SQL/MP to ODBC/MX Date/Time Mappings (continued)

ODBC/MX data typeSQL/MP data type

SQL_TIMESTAMPDATETIME MINUTE TO FRACTION

SQL_TIMEDATETIME SECOND

SQL_TIMESTAMPDATETIME SECOND TO FRACTION

SQL DATETIME RETRIEVALDATETIME VALUE RETRIEVAL

Microsoft escape clauses

ODBC/MX accepts Microsoft escape clauses and translates them into equivalent SQL/MX clauses.

Table 9 lists the SQL/MX equivalents.

Table 9 SQL/MX equivalents for Microsoft escape clauses

SQL/MX equivalentMicrosoft escape clause

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

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

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

join-expression *{ oj join-expression }

INTERVAL sign{ INTERVAL sign

interval-stringinterval-string

interval-qualifierinterval-qualifier }

scalar-function **{ fn scalar-function }

Supported{ call

procedure-name... }

Not supported{ escape 'escape-character' }

Not supported{ [?=]call

procedure-name... }

* ODBC syntax does not include nested joins, while SQL/MX does. ODBC/MX extends the

Microsoft syntax for an outer join.

** Functions are controlled by SQLGetInfo. Only SQL/MX native functions are supported.

Stored Procedures

The drivers support NonStop SQL/MX stored procedures, with the following exceptions:

Pointers to cursors, and return codes are not supported

For more information about stored procedures, see the SQL/MX Guide to Stored Procedures in

Java.

Transaction and cursor behavior

The transaction and cursor behavior is determined by the AUTOCOMMIT setting. Table 10 lists

the transaction and cursor behavior.

Microsoft escape clauses 41

1 2 ... 36 37 38 39 40 41 42 43 44 45 46 ... 61 62

Sin comentarios

Hp Integrity NonStop H-Series Manual de usuario Pagina 41