ODBC Server Reference Manual

Using Pass-Through Mode

HP NonStop ODBC Server Reference Manual—429151-002

6-4

Example Server Option Specification

The following pass-through statement executes the server option specification SET

SQL_ACCESS_MODE:

select "tdm: set sql_access_mode ro"

Example UNLOCK Statement

The following pass-through statement executes the NonStop SQL/MP UNLOCK

statement:

select "tdm: sql unlock table \test.$disk01.persnl.employee"

Example Catalog Utility Statement

The following pass-through statement executes the USERCAT INSTALL catalog utility

statement:

select "tdm: util usercat install \test.$disk01.persnl"

Specifying Server Options in Pass-Through

Mode

The following pass-through commands specify server options that affect the SQL

transactions in the current SQL session (only).

Setting the Access Mode

The following SET command configures the ODBC option SQL_ACCESS_MODE,

which controls the degree of database access given to SQL statements that follow.

specifies that SQL transactions can only read from the database. If this option is

set, only SELECT statements are allowed.

specifies that SQL transactions can both read from and write to the database. This

is the default mode.

SELECT "TDM: SET SQL_ACCESS_MODE { RO } "

{ RW }