ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-32
SYSCAT VALIDATE Statement
For information about viewing and changing the mapped names, see Renaming ODBC
or SQL Server Objects on page 7-7.
How USERCAT REFRESH Affects Stored Procedures
Stored procedures are not necessarily SQL objects. If a stored procedure becomes
invalid or is deleted from ZNUPROC and ZNUPCOL, USERCAT REFRESH cannot re-
create object references for the procedure. Instead, USERCAT REFRESH deletes
from ZNUPCOL any row that corresponds to a parent procedure no longer found in
ZNUPROC.
SYSCAT VALIDATE Statement
Use the SYSCAT VALIDATE statement to report all referential inconsistencies within
the mapping tables.
Nonexistent objects will be reported in your mapping tables if you drop mapped tables
by using NonStop SQL/MP or pass-through mode, or if you drop a table without
dropping dependent views and indexes. When you drop a table that has dependent
objects, the dependent objects are dropped from the NonStop SQL/MP catalog, but
they remain in the mapping tables. For more information, see DROP TABLE in
Section 3, CORE SQL Language,or Section 4, Transact-SQL Language.
Mapping tables will be missing if you accidentally purge them.
SYSCAT VALIDATE also reports any object owner name not found in the system users
(ZNSUS) mapping table.
You can validate the system catalog only if you are a privileged user.
SYSCAT VALIDATE has the following syntax:
output-filename
specifies the NonStop SQL/MP table name of the log table where command
response messages are written. The log table is an unaudited, entry sequenced
table that NOSUTIL creates in the NonStop ODBC master catalog and creates a
mapping entry. If a table that has the same name as output-filename already
exists, NOSUTIL returns an error and the USERCAT INSTALL statement
terminates.
Note. USERCAT REFRESH truncates object names that are more than 8 characters long. To
preserve a longer object name, manually add the object to ZNUOBJ by executing ADD TABLE,
INDEX, or VIEW.
USERCAT REFRESH also changes an object name in ZNUOBJ if you change the owner of
the object from NonStop SQL/MP.
SYSCAT VALIDATE [ LOG output-filename ]