ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-73
Query Status Log (QST_LOG) Statements
REMOVE PROFILE
The REMOVE PROFILE statement removes a profile entry from the ZNSPROF table.
To execute REMOVE PROFILE, you must be a privileged user.
profile-name
specifies the profile you want to remove.
Considerations – REMOVE PROFILE
The REMOVE PROFILE statement:
•
Removes the entry for profile-name from ZNSPROF
•
Generates an error if profile-name is referenced in any logical username record
in ZNSUS
•
Generates an error if you are not a privileged user
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
Example
REMOVE PROFILE myprofl
Query Status Log (QST_LOG) Statements
Use the following statements for NonStop ODBC Server query status log (QST_LOG)
tables:
•
CREATE QST_LOG
•
DROP QST_LOG
CREATE QST_LOG
The CREATE QST_LOG statement creates a new query status log table named
ZNUQST and registers the table as a NonStop ODBC Server object in the specified
database.
IN database-name
is an alphanumeric string up to 60 characters in length that specifies the name of
the database in which to register the query status log table. The database you
specify must be a customized NonStop ODBC Server database.
REMOVE PROFILE profile-name [ UPDATE_SYSTEM_CONFIG ]
CREATE QST_LOG IN database-name [ SECURE security-string ]