ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-108
TRACE Statements
DROP TRA_LOG
The DROP TRA_LOG statement drops an existing trace log table. To execute DROP
TRA_LOG, you must be a privileged user.
table-name
specifies the qualified name of the trace log table to drop.
Considerations – DROP TRA_LOG
The DROP TRA_LOG statement:
•
Drops the specified trace log table
•
Removes the mapping entry for the log table in the specified database
•
Preserves the entry in ZNSPROF for the log table
•
Generates an error if database-name is not a customized NonStop ODBC Server
database
•
Generates an error if you do not have sufficient privileges to execute DROP
TRA_LOG
•
Generates an error if the associated SQL DROP TABLE statement fails for either
resource or privilege reasons
Example
DROP TRA_LOG sf_disk01_tralog01
TRACE Statements
Use the following statements to configure and manage named trace entities:
•
ADD TRACE
•
MODIFY TRACE
•
REMOVE TRACE
DROP TRA_LOG table-name