Software User guide

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)
Source and NotesData TypeIncomplete QueriesComplete Queries
Derived from CPU,
PIN
INT
UNSIGNED
PINPIN
STARTSMALLINT
UNSIGNED
START_PRIORITY
STARTCHAR(18) or
NCHAR(18)
PROCESS_NAMEPROCESS_NAME
STARTCHAR(108) or
NCHAR(108)
SESSION_IDSESSION_ID
STARTCHAR(8) or
NCHAR(8)
USER_IDUSER_ID
STARTCHAR(20) or
NCHAR(20)
USER_NAMEUSER_NAME
STARTCHAR(15) or
NCHAR(15)
CLIENT_IDCLIENT_ID
STARTCHAR(130) or
NCHAR(130)
APPLICATION_IDAPPLICATION_ID
STARTCHAR(128) or
NCHAR(128)
DATASOURCEDATASOURCE
ENDVARCHAR(160)
or NCHAR
VARYING(160)
QUERY_ID when available (see
“Format of the Query ID Field”
(page 25))
QUERY_ID
STARTCHAR(30) or
NCHAR(30)
STATEMENT_IDSTATEMENT_ID
ENDCHAR(36) or
NCHAR(36)
STATEMENT_TYPESTATEMENT_TYPE
'COMPLETE',
'INCOMPLETE',
'MULTIROW',
'ERRTERMINATION',
derived from
STATEMENT
STATUS and
SEQUENCE
NUMBER
CHAR(14) or
NCHAR(14)
STATEMENT_STATESTATEMENT_STATE
Y or NCHAR(1) or
NCHAR(1)
QUERY_TEXT_IS_MULTIROWQUERY_TEXT_IS_MULTIROW
END, else START,
else ”
CHAR(6) or
NCHAR(6)
ERROR_CODEERROR_CODE
STARTSMALLINT
UNSIGNED
SEQUENCE_NUMSEQUENCE_NUM
STARTSMALLINT
UNSIGNED
SEQUENCE_SIZESEQUENCE_SIZE
STARTTIMESTAMPQUERY_START_DATETIMEQUERY_START_DATETIME
STARTDATEQUERY_START_DATEQUERY_START_DATE
STARTTIMEQUERY_START_TIMEQUERY_START_TIME
STARTTIMESTAMPQUERY_START_DATETIME_UTCQUERY_START_DATETIME_UTC
STARTDATEQUERY_START_DATE_UTCQUERY_START_DATE_UTC
Query Statistics 27