ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-36
SYSCAT UPGRADE Statement
If you omit session-id, all temporary objects that belong to the current user are
dropped.
Examples
The following examples show uses of CLEANUP.
Drop All Temporary Objects
The following statement drops all temporary objects in the PERSNL catalog:
cleanup $oook.persnl
All temporary objects are dropped regardless of who owns them.
Drop Temporary Objects for Several Catalogs and a Specific User
The following statement drops temporary objects in the PERSNL, SALES and INVENT
catalogs if the objects are owned by the user PUBS_JANET:
cleanup $oook.persnl $oook.sales $oook.invent user pubs_janet
Effects of CLEANUP
CLEANUP does the following:
•
Deletes entries from the appropriate mapping tables
•
Drops temporary objects from the NonStop SQL/MP catalog
•
Generates an error if you are not a privileged user
•
Generates an error for each NonStop SQL/MP object you are not authorized to
purge
•
Generates an error if you are not the same user that customized the specified
catalog or database
•
Generates an error if catalog-name is not a customized NonStop ODBC Server
system catalog
•
Generates an error if the temporary table to clean up is open when you execute
CLEANUP
SYSCAT UPGRADE Statement
Use the SYSCAT UPGRADE statement to change the mapping tables so that the
system catalog conforms to the current version specification.
SYSCAT UPGRADE has the following syntax:
SYSCAT UPGRADE