ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-13
Updating the Mapping Tables
•
You create an object in a customized catalog and need to access it using the
NonStop ODBC Server.
•
You drop an object from a customized catalog and need to create another object
by the same name, or you want the object to be removed from the NonStop ODBC
Server mapping table.
•
You create a catalog and want to access it using the NonStop ODBC Server.
•
You rename an object.
These situations indicate when you would not need to update the mapping tables after
using pass-through mode:
•
The pass-through statement operated on a catalog that is not customized.
•
You created an object in a customized catalog but do not need to access it using
the NonStop ODBC Server.
Updating With the Catalog Utility Statements
To update the mapping tables to reflect changes made in pass-through mode, use one
of the following catalog utility statements:
For detailed information on the catalog utility statements, see Section 7, Managing
Customized Catalogs.
Frequency of Using the Catalog Utility Statements
You do not need to update the mapping tables each time you use pass-through mode;
you can update them only when you need to remove extraneous entries or to map
objects that you need to access through the NonStop ODBC Server. Also, because the
catalog utility statements affect an entire catalog, you can update the mapping table
after executing several pass-through statements. For example, you can do the
following:
•
Execute one REFRESH statement after creating several tables, views, and
indexes in pass-through mode.
•
Execute one REFRESH statement after dropping several tables in pass-through
mode.
•
Execute one REFRESH statement after creating one table and renaming another
table in pass-through mode.
USERCAT INSTALL Customizes a NonStop SQL/MP catalog
USERCAT REFRESH Adds a mapping table entry for any object that is not
mapped and removes mapping table entries for nonexistent
objects