HP Neoview Release 2.4 Software User Manual

Page 27

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)

Source and Notes

Data Type

Incomplete Queries

Complete Queries

Derived from CPU,
PIN

INT
UNSIGNED

START

SMALLINT
UNSIGNED

START_PRIORITY

START

CHAR(18) or
NCHAR(18)

PROCESS_NAME

START

CHAR(108) or
NCHAR(108)

SESSION_ID

START

CHAR(8) or
NCHAR(8)

USER_ID

START

CHAR(20) or
NCHAR(20)

USER_NAME

START

CHAR(15) or
NCHAR(15)

CLIENT_ID

START

CHAR(130) or
NCHAR(130)

APPLICATION_ID

START

CHAR(128) or
NCHAR(128)

DATASOURCE

END

VARCHAR(160)
or NCHAR
VARYING(160)

QUERY_ID when available (see

“Format of the Query ID Field”
(page 25)

)

QUERY_ID

START

CHAR(30) or
NCHAR(30)

STATEMENT_ID

END

CHAR(36) or
NCHAR(36)

STATEMENT_TYPE

'COMPLETE',
'INCOMPLETE',
'MULTIROW',
'ERRTERMINATION',
derived from
STATEMENT
STATUS and
SEQUENCE
NUMBER

CHAR(14) or
NCHAR(14)

STATEMENT_STATE

Y or N

CHAR(1) or
NCHAR(1)

QUERY_TEXT_IS_MULTIROW

END, else START,
else ”

CHAR(6) or
NCHAR(6)

ERROR_CODE

START

SMALLINT
UNSIGNED

SEQUENCE_NUM

START

SMALLINT
UNSIGNED

SEQUENCE_SIZE

START

TIMESTAMP

QUERY_START_DATETIME

START

DATE

QUERY_START_DATE

START

TIME

QUERY_START_TIME

START

TIMESTAMP

QUERY_START_DATETIME_UTC

START

DATE

QUERY_START_DATE_UTC

Query Statistics