ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-37
ZNSTRA (For Trace Data)
ZNSTRA (For Trace Data)
The table ZNSTRA contains the trace description pointed to by a user profile.
.
Table 8-18. Description of ZNSTRA (page 1 of 2)
Column Name
Primary Key Unique Index
Data Type Description
TRA_NAME
x_
VARCHAR (60) A unique key for associating a
trace definition with a profile.
TRA_LOGTABLE_
NAME
__
VARCHAR (182) NonStop ODBC Server table
name to which the log is written.
TRA_LEVEL
__
VARCHAR (60) Reserved for future use.
LOG_TO_
HOMETERM
__
CHAR (1) Record copying trace indicator:
Y TRACE records are copied to
the HOMETERM of the
NSODBC server process
N TRACE records are not
copied to the HOMETERM
INPUT_STREAM
__
CHAR (1) Read messages trace indicator:
Y TRACE records each
message read by the
NSODBC server
N TRACE does not record each
message read
OUTPUT_STREAM
__
CHAR (1) Written messages trace indicator:
Y TRACE records each
message written by the
NSODBC server
N TRACE does not record
each message written by the
NSODBC server.
NSSQL
__
CHAR (1) SQL statement trace indicator:
Y SQL statements
prepared or executed
are traced
N SQL statements are not
traced
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index