ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
ix
6. Using Pass-Through Mode (continued)
6. Using Pass-Through Mode (continued)
Using SELECT Statements 6-14
Using PREPARE and EXECUTE Statements 6-14
Examples of Using Pass-Through Mode 6-15
Creating or Altering Catalogs 6-15
Creating or Altering Tables 6-16
Creating or Altering Views 6-18
Managing Resource Accounting 6-19
Managing Indexes 6-19
Locking Data 6-20
Using PREPARE, EXECUTE, and RELEASE Statements 6-20
Managing Traces 6-20
7. Managing Customized Catalogs
Summary of Tasks 7-2
Locating Objects Using the Mapping Tables 7-4
Listing Customized Catalogs 7-5
Locating an Object Using the ODBC/SQL Server Object Name 7-5
Locating an Object Using the NonStop SQL/MP Object Name 7-6
Renaming ODBC or SQL Server Objects 7-7
How Names Are Assigned 7-7
Listing the Mapped Object Names 7-8
Changing ODBC/SQL Server Object Names 7-10
Running the Catalog Utility Statements 7-13
Executing the Statements From a TACL Prompt 7-14
Running the Statements Using Pass-Through Mode 7-16
Privileged Users 7-17
Customizing Catalogs 7-18
SYSCAT INSTALL Statement 7-18
USERCAT INSTALL Statement 7-20
Decustomizing Catalogs 7-22
SYSCAT DEINSTALL Statement 7-22
USERCAT DEINSTALL Statement 7-24
Maintaining Catalogs 7-27
SYSCAT REFRESH Statement 7-27
USERCAT REFRESH Statement 7-29
SYSCAT VALIDATE Statement 7-32
USERCAT VALIDATE Statement 7-33
CLEANUP Statement 7-35