HP Neoview Release 2.5 Software - Manual (Page 120)

This table indicates which fields are present for completed and incomplete queries. The source
of data fields indicates whether the value is collected at the start of the query or at the end. Unless
indicated here, field descriptions are those provided above for ODBC_QUERY_STATS_V1.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for ODBC_QUERY_STATS_V2 fields is SEGMENT_ID, NODE_ID,
SEQUENCE_NUM and the date/time fields (QUERY_START_DATETIME_UTC and the other
date fields.
Table E-7 ODBC_QUERY_STATS_V2 Fields
Source and Notes Data Type Incomplete Queries Complete Queries
START CHAR(10) or
NCHAR(10) SEGMENT_NAME SEGMENT_NAME
START INT
UNSIGNED SEGMENT_ID SEGMENT_ID
START INT
UNSIGNED NODE_ID NODE_ID
Derived from
CPU, PIN INT
UNSIGNED PIN PIN
START SMALLINT
UNSIGNED START_PRIORITY
START CHAR(18) PROCESS_NAME PROCESS_NAME
START CHAR(108) SESSION_ID SESSION_ID
START CHAR(8) USER_ID USER_ID
START CHAR(128) USER_NAME USER_NAME
START CHAR(15) CLIENT_ID CLIENT_ID
START CHAR(130) APPLICATION_ID APPLICATION_ID
START CHAR(128) DATASOURCE DATASOURCE
END VARCHAR(160) QUERY_ID when available QUERY_ID
START CHAR(30) STATEMENT_ID STATEMENT_ID
END CHAR(36) STATEMENT_TYPE STATEMENT_TYPE
'COMPLETE',
'INCOMPLETE',
'MULTIROW',
'ERRTERMINATION',
derived from
STATEMENT
STATUS and
SEQUENCE
NUMBER CHAR(14) STATEMENT_STATE STATEMENT_STATE
Y or N CHAR(1) QUERY_TEXT_IS_MULTIROW QUERY_TEXT_IS_MULTIROW
END, else START,
else ” CHAR(6) ERROR_CODE ERROR_CODE
START SMALLINT
UNSIGNED SEQUENCE_NUM SEQUENCE_NUM
START SMALLINT
UNSIGNED SEQUENCE_SIZE SEQUENCE_SIZE
120 Pre-R2.5 Query Statistics Views