HP Neoview Release 2.5 Software - Manual (Page 118)

Table E-6 ODBC_QUERY_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Cumulative number of rows accessed. LARGEINT ROWS_ACCESSED
Cumulative number of rows
retrieved. LARGEINT ROWS_RETRIEVED
Number of rows inserted, updated,
deleted. LARGEINT NUM_ROWS_IUD
Total NDCS server real time, in
microseconds, from the time the
execute or execdirect started to the
time the results were sent back. LARGEINT QUERY_ELAPSED_TIME
Node processing time. LARGEINT MASTER_EXECUTION_TIME
Total number of executes performed
on this statement. LARGEINT TOTAL_EXECUTES
Process identification number of the
NDCS server. INTEGER UNSIGNED PIN
START if this record contains
information collected at the start of
the query, or END if it contains
statistics collected at the end of the
query.
CANCELLED for queries killed
through Neoview Query Viewer. CHARACTER(5) STATEMENT_STATUS
Execution priority of the NDCS
process at the time the connection
request is received. SMALLINT UNSIGNED START_PRIORITY
Prepare error code. A value of 0
indicates that the prepare was
successful. CHARACTER(6) ERROR_CODE
Client data source name used at the
time of the connection. CHARACTER(128) DATASOURCE
Client application name or main
window caption. CHARACTER(130) APPLICATION_ID
Client workstation TCP/IP or
NetBios/network name. CHARACTER(15) CLIENT_ID
Name of the Neoview segment used
by the data source. CHARACTER(10) SEGMENT_NAME
Process name of the NDCS server that
is the parent of the query. The format
of this name is
\segment_name.$process_name
(e.g., \NEO0101.$XYZ. CHARACTER(18) PROCESS_NAME
A deprecated internal representation
of a Neoview role. CHARACTER(8) USER_ID
The name, used at time of connection,
to identify a Neoview user. CHARACTER(128) USER_NAME
Unique statement ID generated by
the NDCS SQL server at the time the
Prepare command was received. CHARACTER(30) STATEMENT_ID
118 Pre-R2.5 Query Statistics Views