
Table C-6 ODBC_QUERY_STATS_V2 Fields (continued)
Source and NotesData TypeIncomplete QueriesComplete Queries
STARTCHAR(8)USER_IDUSER_ID
STARTCHAR(128)USER_NAMEUSER_NAME
STARTCHAR(15)CLIENT_IDCLIENT_ID
STARTCHAR(130)APPLICATION_IDAPPLICATION_ID
STARTCHAR(128)DATASOURCEDATASOURCE
ENDVARCHAR(160)QUERY_ID when availableQUERY_ID
STARTCHAR(30)STATEMENT_IDSTATEMENT_ID
ENDCHAR(36)STATEMENT_TYPESTATEMENT_TYPE
'COMPLETE',
'INCOMPLETE',
'MULTIROW',
'ERRTERMINATION',
derived from
STATEMENT
STATUS and
SEQUENCE
NUMBER
CHAR(14)STATEMENT_STATESTATEMENT_STATE
Y or NCHAR(1)QUERY_TEXT_IS_MULTIROWQUERY_TEXT_IS_MULTIROW
END, else START,
else ”
CHAR(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
STARTTIMEQUERY_START_TIME_UTCQUERY_START_TIME_UTC
END, or NULL for
an incomplete
query
TIMESTAMPQUERY_START_DATETIMEQUERY_END_DATETIME
END, or NULL for
an incomplete
query
DATEQUERY_START_DATEQUERY_END_DATE
END, or NULL for
an incomplete
query
TIMEQUERY_START_TIMEQUERY_END_TIME
END, or NULL for
an incomplete
query
TIMESTAMPQUERY_START_DATETIME_UTCQUERY_END_DATETIME_UTC
END, or NULL for
an incomplete
query
DATEQUERY_START_DATE_UTCQUERY_END_DATE_UTC
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2 105
Comentarios a estos manuales