HP Neoview Release 2.4 Software - Manual (Page 38)

• 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.
The primary key for ODBC_SESSION_STATS_V1 field definition is SEGMENT_ID, NODE_ID,
and SESSION_EVENT_DATETIME_UTC.
Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions
Description Data Type Field Name
Segment number of the NDCS
server that reported the
statistics. INTEGER UNSIGNED SEGMENT_ID
Processing node number of the
NDCS server that generated the
session. INTEGER UNSIGNED NODE_ID
ANSI SQL Timestamp, in Local
Civil Time, indicating when the
statistics were recorded in the
Repository. TIMESTAMP(6) SESSION_EVENT_DATETIME
ANSI SQL date, in Local Civil
Time, when the statistics were
recorded in the Repository. DATE SESSION_EVENT_DATE
ANSI SQL time, in Local Civil
Time, when the statistics were
recorded in the Repository. TIME(6) SESSION_EVENT_TIME
ANSI SQL Timestamp, in
Coordinated Universal Time,
indicating when the statistics
were recorded in the
Repository. TIMESTAMP(6) SESSION_EVENT_DATETIME_UTC
ANSI SQL date, in Coordinated
Universal Time, when the
statistics were recorded in the
Repository. DATE SESSION_EVENT_DATE_UTC
ANSI SQL time, in Coordinated
Universal Time, when the
statistics were recorded in the
Repository. TIME(6) SESSION_EVENT_TIME_UTC
Unique session ID generated by
the NDCS server when the
connection was established. For
information about the format,
see the note after this table. CHAR(108)or NCHAR(108) SESSION_ID
Message sequence number
generated by NDCS.
Numbering starts at 0 and is
incremented by 1 for each new
record. SMALLINT UNSIGNED SEQUENCE_NUM
Repository-assigned value.
Used internally. INTEGER UNSIGNED METRIC_CLASS_ID
Repository-assigned value.
Used internally. INTEGER UNSIGNED METRIC_CLASS_VERSION
38 Repository Views