beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 39

background image

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name

Total number of SQL catalog
statements sent by the HP
ODBC driver to the NDCS SQL
server.

LARGEINT

TOTAL_CATALOG_STMTS

Total number of SQL CLOSE
calls sent by the HP ODBC
driver to the NDCS SQL server.

LARGEINT

TOTAL_CLOSES

Total number of SQL DELETE
statements sent by the HP
ODBC driver to the NDCS SQL
server. Does not include
internally generated SQL
statements.

LARGEINT

TOTAL_DELETE_STMTS_EXECUTED

Total number of SQL statement
execution errors detected by the
NDCS SQL server.

LARGEINT

TOTAL_ERRORS

Total number of SQLExecDirect
calls.

LARGEINT

TOTAL_EXECDIRECTS

Total number of SQLExecute
calls.

LARGEINT

TOTAL_EXECUTES

Total number of SQLFetch calls.

LARGEINT

TOTAL_FETCHES

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

ODBC Session Data

39