ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-74
Query Status Log (QST_LOG) Statements
SECURE security-string
is a four-character alphabetic string that specifies the Guardian read, write,
execute, and purge (RWEP) access for the query status log table. For more
information about security for NonStop SQL/MP objects, see the “Security” entry in
the NonStop SQL/MP Reference Manual.
Considerations – CREATE QST_LOG
The CREATE QST_LOG statement:
•
Generates an error if database-name is not a customized NonStop ODBC Server
database
•
Generates an error if the associated SQL CREATE TABLE statement fails for
either resource or privilege reasons.
Example
CREATE QST_LOG IN sf_admin_cat SECURE NONO
DROP QST_LOG
The DROP QST_LOG statement drops an existing query status log table. To execute
DROP QST_LOG, you must be a privileged user.
FROM database-name
specifies the name of the database from which to drop the query status log table;
database-name is an alphanumeric string up to 60 characters in length. This
database must be a customized NonStop ODBC Server database.
Considerations – DROP QST_LOG
The DROP QST_LOG statement:
•
Removes the mapping entry for the log table in database-name
•
Preserves the entry in ZNSPROF for the log table
•
Generates an error if you do not have sufficient privileges to execute DROP
QST_LOG
•
Generates an error if the associated SQL DROP TABLE statement fails for either
resource or privilege reasons
Example
DROP QST_LOG FROM sf_admin_cat
DROP QST_LOG FROM database-name