ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-38
Maintaining Mapping Tables
•
Generates an error if the specified catalog is not a NonStop ODBC Server version
100 or 110 catalog
Maintaining Mapping Tables
Table 7-4 lists the NonStop ODBC Server mapping table statements by type. You can
execute these statements either from the TACL prompt by running NOSCOM or from
the NonStop ODBC Server Configuration Manager. Use these statements to add items
to, change existing items in, and delete items from the mapping tables.
Because the NonStop ODBC Server is so flexible, your installation can use defaults
other than the initial ones provided. Initial defaults are listed in Appendix D, Summary
of System Installation Defaults.
Table 7-4. Summary of Mapping Table Statements (page 1 of 3)
Statement Type What This Type of Statement Affects
ACC_LOG
CREATE ACC_LOG
DROP ACC_LOG
Accounting log tables
ALIAS
ADD ALIAS
MODIFY ALIAS
REMOVE ALIAS
Mapping of alias usernames to logical
usernames
CONTROL
ADD CONTROL
REMOVE CONTROL
Stored NonStop SQL/MP CONTROL statements
GOVERNING
ADD GOVERNING
MODIFY GOVERNING
REMOVE GOVERNING
Resource governing policy entities
INDEX
ADD INDEX
REMOVE INDEX
Visibility of NonStop SQL/MP index tables
NET_SERVICE
ADD NET_SERVICE
MODIFY NET_SERVICE
REMOVE NET_SERVICE
Named network service configurations
PROFILE
ADD PROFILE
MODIFY PROFILE
REMOVE PROFILE
Named profile configurations