ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-19
Managing Resource Accounting
After creating a view in pass-through mode, you can update the mapping tables using
the REFRESH statement:
select "tdm: util usercat refresh $vol3.persnl"
Managing Resource Accounting
The following example statement starts resource accounting:
select "tdm: set acc_mode_on y"
The following example statement stops resource accounting:
select "tdm: set acc_mode_on n"
For details on resource accounting, see the NonStop ODBC Server Installation and
Management Manual.
Managing Indexes
The following examples show how to use pass-through mode to manage indexes.
Creating a Descending Index
All indexes created with the NonStop ODBC Server using the SQL statement CREATE
INDEX use ascending keys. You can create an index with a descending key, however,
by using pass-through mode:
select "tdm: sql create unique index $vol3.prsntabs.xempnam
on $vol3.prsntabs.employee
(last_name descending,
first_name)
catalog $vol3.persnl"
After creating an index in pass-through mode, you can update the mapping tables
using the REFRESH statement:
select "tdm: util usercat refresh $vol3.persnl"