ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-11
Available NonStop SQL/MP Statements
Table 6-2. DCL Statements Available in Pass-Through Mode
Statement Description
Mapping
Table
Action
Needed
Mapping Table Action
Description
CONTROL
EXECUTOR
Allows or prohibits
parallel evaluation of a
query by multiple SQL
executors.
None –
CONTROL
QUERY
Specifies whether SQL
should optimize the
speed of processing
either for returning the
first few rows found or
for returning all rows
found.
None –
CONTROL
TABLE
Specifies options to
control locks and opens
on identified tables and
views.
None –
FREE
RESOURCES
Releases locks held by
the current TMF
transaction.
None –
LOCK TABLE Locks a table or
underlying tables of a
view and associated
indexes.
None –
UNLOCK
TABLE
Releases locks held on
nonaudited tables or
views.
None –
Table 6-3. DML Statements Available in Pass-Through Mode (page 1 of 2)
Statement Description
Mapping
Table
Action
Needed
Mapping Table Action
Description
DELETE Deletes rows from a
table or protection view.
None –