ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-49
ZNUMTRX (For Resource Accounting Log Data)
STMT_TYPE
––
CHAR (1) Type of statement being
processed:
S SELECT
D DELETE
UUPDATE
IINSERT
L DDL
C DCL
OOther
STMT_STATUS
––
CHAR (1) Current status of the statement
query:
C Statement completed
P Statement prepared
X Statement cancelled by user
Q NonStop SQL error occurred
STMT_ORIGIN
––
CHAR (1) Flag indicating whether a
statement is from a client or
internally generated:
U User generated
I Internally generated
ESTIMATED_COST
––
INT (8) Estimated cost of the NonStop
SQL/MP PREPARE statement.
STMT_CACHED
––
CHAR (1) Indicates whether the statement
was already in cache:
N Not cached
Y Cached for the first time
R Reused from cache
RECORDS_
ACCESSED
––
INT (8) Number of records used
generating the intermediate and
final result sets.
RECORDS_USED
––
INT (8) Number of records used
generating the intermediate and
final result sets.
DISC_READS
––
INT (8) Number of physical disk reads
performed.
Table 8-23. Description of ZNUMTRX (page 5 of 6)
Column Name
Primary Key Unique Index
Data Type Description
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