HP Neoview Release 2.4 Software - Manual (Page 103)

Table C-5 ODBC_QUERY_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Client data source name used at the
time of the connection. CHARACTER(128) DATASOURCE
Client application name or main
window caption. CHARACTER(130) APPLICATION_ID
Client workstation TCP/IP or
NetBios/network name. CHARACTER(15) CLIENT_ID
Name of the Neoview segment used
by the data source. CHARACTER(10) SEGMENT_NAME
Process name of the NDCS server that
is the parent of the query. The format
of this name is
\segment_name.$process_name
(e.g., \NEO0101.$XYZ. CHARACTER(18) PROCESS_NAME
A deprecated internal representation
of a Neoview role. CHARACTER(8) USER_ID
The name, used at time of connection,
to identify a Neoview user. CHARACTER(128) USER_NAME
Unique statement ID generated by
the NDCS SQL server at the time the
Prepare command was received. CHARACTER(30) STATEMENT_ID
Compiler-provided value, one of:
SQL_SELECT_UNIQUE,
SQL_SELECT_NON_UNIQUE
SQL_INSERT_UNIQUE,
SQL_INSERT_NON_UNIQUE,
SQL_UPDATE_UNIQUE,
SQL_UPDATE_NON_UNIQUE,
SQL_DELETE_UNIQUE,
SQL_DELETE_NON_UNIQUE,
SQL_CONTROL,
SQL_SET_TRANSACTION,
SQL_SET_CATALOG,
SQL_SET_SCHEMA, SQL_OTHER,
SQL_UNKNOWN,
SQL_CALL_NO_RESULT_SETS,
SQL_CALL_WITH_RESULT_SETS,
SQL_SP_RESULT_SET,
SQL_NOT_SUPPORTED. For
definitions of SQL statement types,
see the Neoview SQL Reference
Manual. For example, to find
information about
SQL_SET_TRANSACTION, look up
the SET TRANSACTION statement
in the Neoview SQL Reference Manual.
The suffix _UNIQUE indicates that
the statement operates on a single
row. The suffix _NON_UNIQUE
indicates that the statement could
operate on multiple rows. In the
START row for an ExecuteDirect
query, the value of this field is always
SQL_UNKNOWN; in the END row,
it has its proper value. CHARACTER(36) STATEMENT_TYPE
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1 103