ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-2
Setting Server Options
Setting Server Options
You can enter commands in pass-through mode to specify the configuration of certain
server options dealing with the SQL access mode (read/write or read only), the cursor
mode (update or read only), the maximum number of rows returned in response to a
query, and the transaction isolation level (browse, repeatable, or stable).
Using the Trace Feature
The NonStop ODBC Server provides trace options that you can specify to record
information such as SQL statements sent to the NonStop ODBC Server, and SQL/MP
statements and error messages generated by the NonStop ODBC Server.
Using pass-through mode you can initiate, start, and stop traces using the following
trace options:
•
TRA_NAME
•
TRA_LOGTABLE_NAME
•
LOG_TO_HOMETERM
•
INPUT_STREAM
•
OUTPUT_STREAM
•
NSSQL
•
TRA_ERROR
•
CACHE_STATISTICS
•
SP_WRITE
•
SP_READ
For example, the following pass-through statement sets trace options:
select "tdm: set tra_name traceit tra_log_tablename
sqldb.sql_user.tracetab sql_ nssql y tra_error y
cache_statistics y"
For more information about trace options, see the ADD TRACE statement in Section 7,
Managing Customized Catalogs.
Using Resource Accounting
You can start and stop resource accounting with a single command in a user session.
For examples, see Examples of Using Pass-Through Mode
on page 6-15.