HP Neoview Release 2.3 Software - Manual (Page 37)

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Total number of SQL INSERT
statements sent by the HP
ODBC driver to the NDCS SQL
server. Does not include
internally generated SQL
statements. LARGEINT TOTAL_INSERT_STMTS_EXECUTED
Total NDCS server real time, in
microseconds, from the time the
connection started to the time
it was closed. LARGEINT TOTAL_ODBC_ELAPSED_TIME
Total NDCS server CPU time,
in microseconds, from the time
the connection started to the
time it was closed. Does not
include Neoview SQL compile
time. LARGEINT TOTAL_MASTER_EXEC_EXECUTION_TIME
Total number of SQLPrepare
calls. LARGEINT TOTAL_PREPARES
Total number of SQL SELECT
statements sent by the HP
ODBC driver to the NDCS SQL
server. Does not include
internally generated SQL
statements. LARGEINT TOTAL_SELECT_STMTS_EXECUTED
Total number of SQL UPDATE
statements sent by the HP
ODBC driver to the NDCS SQL
server. Does not include
internally generated SQL
statements. LARGEINT TOTAL_UPDATE_STMTS_EXECUTED
Total number of SQL statement
warnings detected by the
NDCS SQL server. LARGEINT TOTAL_WARNINGS
Process identification number
of the NDCS server. INTEGER UNSIGNED PIN
Execution priority of the NDCS
process at the time the
connection request was
received. SMALLINT UNSIGNED START_PRIORITY
START if this record contains
information collected at the
start of the session, or END if it
contains statistics collected at
the end of the session. CHAR(5) or NCHAR(5) SESSION_STATUS
Client application name or
main window caption. CHAR(130) or NCHAR(130) APPLICATION_ID
Client workstation TCP/IP or
NetBios/network name. CHAR(15) or NCHAR(15) CLIENT_ID
Name of the NDCS component
to which the statistics apply,
e.g., ODBC_Server. CHAR(20) or or NCHAR(20) COMPONENT_NAME
Client data source name used
at the time of the connection. CHAR(128) or NCHAR(128) DATASOURCE
ODBC Session Data 37