HP Neoview Release 2.4 Software - Manual (Page 105)

Table C-6 ODBC_QUERY_STATS_V2 Fields (continued)
Source and Notes Data Type Incomplete Queries Complete Queries
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
START TIMESTAMP QUERY_START_DATETIME QUERY_START_DATETIME
START DATE QUERY_START_DATE QUERY_START_DATE
START TIME QUERY_START_TIME QUERY_START_TIME
START TIMESTAMP QUERY_START_DATETIME_UTC QUERY_START_DATETIME_UTC
START DATE QUERY_START_DATE_UTC QUERY_START_DATE_UTC
START TIME QUERY_START_TIME_UTC QUERY_START_TIME_UTC
END, or NULL for
an incomplete
query TIMESTAMP QUERY_START_DATETIME QUERY_END_DATETIME
END, or NULL for
an incomplete
query DATE QUERY_START_DATE QUERY_END_DATE
END, or NULL for
an incomplete
query TIME QUERY_START_TIME QUERY_END_TIME
END, or NULL for
an incomplete
query TIMESTAMP QUERY_START_DATETIME_UTC QUERY_END_DATETIME_UTC
END, or NULL for
an incomplete
query DATE QUERY_START_DATE_UTC QUERY_END_DATE_UTC
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2 105