HP Neoview Release 2.3 Software User Manual
Page 24
Table 3-2 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) or
NCHAR(128)
DATASOURCE
Client application name or main
window caption.
CHARACTER(130) or
NCHAR(128)
APPLICATION_ID
Client workstation TCP/IP or
NetBios/network name.
CHARACTER(15) or NCHAR(15)
CLIENT_ID
Name of the Neoview segment used
by the data source.
CHARACTER(10) or NCHAR(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) or NCHAR(18)
PROCESS_NAME
A deprecated internal representation
of a Neoview role.
CHARACTER(8) or NCHAR(8)
USER_ID
The name, used at time of connection,
to identify a Neoview user. One or
more such names can map internally
to the same Neoview role.
CHARACTER(20) or NCHAR(20)
USER_NAME
Unique statement ID generated by
the NDCS SQL server at the time the
Prepare command was received.
CHARACTER(30) or NCHAR(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) or NCHAR(36)
STATEMENT_TYPE
24
Repository Views