Hp Neoview Release 2.3 Software Uživatelský manuál stáhnout pdf (Strana 26)

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)

Source and NotesData TypeIncomplete QueriesComplete Queries

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

Note following table)

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

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

26 Repository Views

1 2 ... 21 22 23 24 25 26 27 28 29 30 31 ... 73 74

Komentáře k této Příručce

Žádné komentáře

Hp Neoview Release 2.3 Software Uživatelský manuál Strana 26

Komentáře k této Příručce

Související produkty a manuály pro Software Hp Neoview Release 2.3 Software