ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-6
Executing a NonStop SQL/MP Statement
level
specifies the isolation level. The following table shows the valid level entries and
their NonStop SQL/MP translations:
If you specify this option, the NonStop ODBC Server applies the appropriate isolation
level to each SQL statement; for example, BROWSE ACCESS is meaningful only if the
SQL statement is a SELECT statement.
If you do not specify this option, the NonStop ODBC Server uses the NonStop SQL/MP
default locking mode, STABLE ACCESS, for all SQL statements.
See the NonStop SQL/MP Reference Manual for additional information about
transaction isolation.
Executing a NonStop SQL/MP Statement
When you issue a NonStop SQL/MP statement in pass-through mode, the NonStop
ODBC Server executes the statement you specify without any translation taking place.
NonStop SQL/MP statements executed in pass-through mode are independent of the
NonStop ODBC Server. Results can be returned in the same way as for SQL
statements entered without using pass-through mode.
Pass-through statements for NonStop SQL/MP use the following syntax:
TDM:
is a required keyword that identifies a pass-through statement.
SQL
is a required keyword that indicates a NonStop SQL/MP statement.
nonstop-sql-statement
specifies the NonStop SQL/MP statement to execute. The statement can contain
up to 1024 characters.
Specify names for catalogs, tables, views, and indexes in Guardian format.
level Entry NonStop SQL/MP Translation
0 BROWSE ACCESS
1 STABLE ACCESS
2 REPEATABLE ACCESS
3 REPEATABLE ACCESS
Note. All of the preceding server options can be set up in a profile record to eliminate the need
for specifying them individually. See ADD PROFILE
on page 7-66.
SELECT "TDM: SQL nonstop-sql-statement"