beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 104

background image

Table E-3 ODBC_QUERY_STATS_V1_2400 Field Definitions (continued)

Description

Data Type

Field Name

START if this record contains
information collected at the start of
the query, or END if it contains
statistics collected at the end of the
query.
CANCELLED for queries killed
through Neoview Query Viewer.

CHARACTER(5)

STATEMENT_STATUS

Execution priority of the NDCS
process at the time the connection
request is received.

SMALLINT UNSIGNED

START_PRIORITY

Prepare error code. A value of 0
indicates that the prepare was
successful. A value of 201 indicates
that the NDCS process stopped or
failed.

CHARACTER(6)

ERROR_CODE

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

104

Pre-R2.5 Query Statistics Views