beautypg.com

HP Neoview Release 2.3 Software User Manual

Page 40

background image

Table 3-6 ODBC_SESSION_STATS_V2 Fields (continued)

Source and
Notes

Data Type

Incomplete Sessions

Complete Sessions

END, or
NULL for an
incomplete
session

DATE

SESSION_END_DATE

SESSION_END_DATE

END, or
NULL for an
incomplete
session

TIME

SESSION_ END _TIME

SESSION_ END _TIME

END, or
NULL for an
incomplete
session

TIMESTAMP

SESSION_START_DATETIME_UTC

SESSION_END_DATETIME_UTC

END, or
NULL for an
incomplete
session

DATE

SESSION_END_DATE_UTC

SESSION_END_DATE_UTC

END, or
NULL for an
incomplete
session

TIME

SESSION_ END _TIME_UTC

SESSION_ END _TIME_UTC

'INCOMPLETE'
or
'COMPLETE'

CHAR(14) or
NCHAR(14)

SESSION_STATE

SESSION_STATE

END, or
NULL for an
incomplete
session

LARGEINT

TOTAL_CATALOG_STMTS

END, or
NULL for an
incomplete
session

LARGEINT

TOTAL_CLOSES

END, or
NULL for an
incomplete
session

LARGEINT

TOTAL_DELETE_STMTS_EXECUTED

END, or
NULL for an
incomplete
session

LARGEINT

TOTAL_ERRORS

END, or
NULL for an
incomplete
session

LARGEINT

TOTAL_EXECDIRECTS

END, or
NULL for an
incomplete
session

LARGEINT

TOTAL_EXECUTES

END, or
NULL for an
incomplete
session

LARGEINT

TOTAL_FETCHES

40

Repository Views