HP Neoview Release 2.3 Software - Manual (Page 26)

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)
Source and Notes Data Type Incomplete Queries Complete Queries
START CHAR(108) or
NCHAR(108) SESSION_ID SESSION_ID
START CHAR(8) or
NCHAR(8) USER_ID USER_ID
START CHAR(20) or
NCHAR(20) USER_NAME USER_NAME
START CHAR(15) or
NCHAR(15) CLIENT_ID CLIENT_ID
START CHAR(130) or
NCHAR(130) APPLICATION_ID APPLICATION_ID
START CHAR(128) or
NCHAR(128) DATASOURCE DATASOURCE
END VARCHAR(160)
or NCHAR
VARYING(160) QUERY_ID when available (see
Note following table) QUERY_ID
START CHAR(30) or
NCHAR(30) STATEMENT_ID STATEMENT_ID
END CHAR(36) or
NCHAR(36) STATEMENT_TYPE STATEMENT_TYPE
'COMPLETE',
'INCOMPLETE',
'MULTIROW',
'ERRTERMINATION',
derived from
STATEMENT
STATUS and
SEQUENCE
NUMBER CHAR(14) or
NCHAR(14) STATEMENT_STATE STATEMENT_STATE
Y or N CHAR(1) or
NCHAR(1) QUERY_TEXT_IS_MULTIROW QUERY_TEXT_IS_MULTIROW
END, else START,
else ” CHAR(6) or
NCHAR(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
26 Repository Views