ODBC Server Reference Manual

Using Pass-Through Mode

HP NonStop ODBC Server Reference Manual—429151-002

6-3

Using Pass-Through Syntax

You use pass-through mode by embedding keywords within a SELECT statement.

Pass-through statements use the following syntax:

TDM:

is a required keyword that identifies a pass-through statement.

SET server-option-specification

specifies the server option specification to be applied. The syntax of the individual

specifications is given under Specifying Server Options in Pass-Through Mode on

page 6-4.

SQL nonstop-sql-statement

specifies the NonStop SQL/MP statement to execute. The syntax of the individual

statements is described in the NonStop SQL/MP Reference Manual.

The required keyword SQL indicates that this pass-through statement is a NonStop

SQL/MP statement.

Specify object names in Guardian format.

UTIL catalog-utility-statement

specifies the catalog utility statement to execute. The syntax of the individual

statements is described in Running the Statements Using Pass-Through Mode on

page 7-16.

The required keyword UTIL indicates that this pass-through statement is a catalog

utility statement.

You cannot execute the catalog utility statements SYSCAT INSTALL or SYSCAT

DEINSTALL as pass-through statements, as this would cause all running servers

to terminate abnormally; the catalog utility generates an error message if it

determines that one of these statements was executed in the pass-through mode.

The SQL PREPARE and SQL EXECUTE statements do not support pass-through

statements.

SELECT "TDM: [ SET server-option-specification ] "

[ SQL nonstop-sql-statement ]

[ UTIL catalog-utility-statement ]

Note. Use a separate SET command for each option.