ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-31
USERCAT REFRESH Statement
Effects of USERCAT REFRESH
USERCAT REFRESH does the following:
•
Checks whether each table, view, and index in the specified catalog has an entry in
the mapping tables. If the object is not entered in the mapping tables, USERCAT
REFRESH enters it.
•
Re-creates any NonStop ODBC Server catalog table, index, or view not found.
•
Adds TABLE, or VIEW, or INDEX, as a logical username to ZNSUS for any object
not found in the mapping table.
•
Corrects any owner or type discrepancies between a mapping entry and its
Guardian file.
•
Deletes any mapping table entry that references a nonexistent NonStop SQL/MP
object.
•
Re-creates any mapping tables that are not found and resupplies them with
values.Generates an error if you are not a privileged user, or if you did not create
this NonStop ODBC Server customized catalog.
•
Generates an error if the catalog is not customized for the NonStop ODBC Server.
If An Object Is Partitioned
For each object with multiple partitions, USERCAT REFRESH adds only one entry to
the ZNUOBJ mapping table. Even if primary and secondary partitions of the same
object are registered in different catalogs, ZNUOBJ has only one entry for the object.
NonStop ODBC Server determines which partition to map as follows:
•
If the primary partition is located in the same subvolume as the specified catalog,
the primary partition is the mapped object.
•
If the primary partition is not located in the same subvolume as the specified
catalog, the first partitioned object in the list of objects in the catalog (TABLES,
INDEXES) is the mapped object.
•
If the object has no local partitions, the primary partition is the mapped object.
How ODBC/SQL Server Object Names Are Assigned
When you customize or refresh a catalog, the NonStop ODBC Server assigns
ODBC/SQL Server names to the objects in the catalog. The NonStop ODBC Server
usually assigns the Guardian file name. For example, a NonStop SQL/MP table named
\TESS.$NOSS.PERSNL.EMPLOYEE is given the ODBC/SQL Server name
EMPLOYEE. Sometimes, however, the NonStop ODBC Server must assign a name
other than the Guardian file name.