Odbc_session_stats_v2 fields – HP Neoview Release 2.3 Software User Manual

Page 39

Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. In the following table:

•

If a data type is given as CHAR or NCHAR, then CHAR applies if the character set is
ISO88591, and NCHAR applies if the character set is UCS2.

•

If a data type is given as VARCHAR or NCHAR VARYING, the VARCHAR applies if the
character set is ISO88591, and NCHAR VARYING applies if the character set is UCS2.

Table 3-6 ODBC_SESSION_STATS_V2 Fields

Source and
Notes

Data Type

Incomplete Sessions

Complete Sessions

START

CHAR(10) or
NCHAR(10)

SEGMENT_NAME

START

INTEGER UNSIGNED

SEGMENT_ID

START

INTEGER UNSIGNED

NODE_ID

START

INTEGER UNSIGNED

END, or
NULL for an
incomplete
session

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 or
NCHAR(15)

CLIENT_ID

START

CHAR(130) or
NCHAR(130)

APPLICATION_ID

START

CHAR(20) or
NCHAR(20)

COMPONENT_NAME

START

CHAR(128) or
NCHAR(128)

DATASOURCE

START

SMALLINT UNSIGNED

SEQUENCE_NUM

START

TIMESTAMP

SESSION_START_DATETIME

START

DATE

SESSION_START_DATE

START

TIME

SESSION_START_TIME

START

TIMESTAMP

SESSION_START_DATETIME_UTC

START

DATE

SESSION_START_DATE_UTC

START

TIME

SESSION_START_TIME_UTC

END, or
NULL for an
incomplete
session

TIMESTAMP

SESSION_START_DATETIME

SESSION_END_DATETIME

ODBC Session Data