Neoview Repository User Guide (R2.4 SP2)

Table C-5 ODBC_QUERY_STATS_V1 Field Definitions (continued)
DescriptionData TypeField 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