ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-107
Trace Log (TRA_LOG) Statements
•
Deletes a mapping entry in ZNUOBJ for the NonStop SQL/MP table indicated by
nssql-filename
•
Deletes primary key and index entries for the table in ZNUIX (if they exist).
•
Generates an error if you are not a privileged user
Example
REMOVE TABLE \persnl.$db1.region1.tblA
Trace Log (TRA_LOG) Statements
The following TRA_LOG statements affect NonStop ODBC Server trace log tables:
•
CREATE TRA_LOG
•
DROP TRA_LOG
CREATE TRA_LOG
The CREATE TRA_LOG statement creates a new trace log table. The table is
registered as a NonStop ODBC Server object in the database. To execute CREATE
TRA_LOG, you must be a privileged user.
table-name
specifies the qualified name of the trace log table to create.
SECURE security-string
is a four-character alphabetic string that specifies the Guardian read, write,
execute, and purge (RWEP) access for the trace 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 TRA_LOG
The CREATE TRA_LOG statement:
•
Generates an error if the database 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 TRA_LOG sf_disk01_tralog01 SECURE "COOO"
CREATE TRA_LOG table-name [ SECURE "security-string" ]