ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
6-1
6 Using Pass-Through Mode
The HP NonStop ODBC Server provides a pass-through mode that you use to execute
HP NonStop SQL/MP statements, catalog utility statements, and trace statements, and
to specify various ODBC options and configurations.
This section covers the following topics:
Activities Available in Pass-Through Mode
You can perform any of the following activities through the use of the pass-through
mode.
Entering NonStop SQL/MP Statements
You might need to execute a NonStop SQL/MP statement to use NonStop SQL/MP
features not available in ODBC/SQL Server. For example, you must use pass-through
mode to do the following NonStop SQL/MP operations:
•
Create a partitioned table
•
Create a nonaudited table
•
Alter table attributes
•
Override the default table attributes
•
Create a primary key
•
Create an index with a descending key
•
Issue control statements (Executor, Query, and Table)
•
Lock or unlock an object
•
Enable parallel query processing
Running Catalog Utilities
The NonStop ODBC Server provides catalog utilities to help you maintain customized
catalogs. You can execute catalog utility statements in pass-through mode.
Name Page
Activities Available in Pass-Through Mode
6-1
Using Pass-Through Syntax 6-3
Specifying Server Options in Pass-Through Mode 6-4
Executing a NonStop SQL/MP Statement 6-6