HP Neoview Release 2.4 Software - Manual (Page 32)

VIEW NEO.HP_METRICS.SQL_TEXT_VW1
This view allows access to the complete SQL text for a query.
When the SQL text for a query is 254 characters or fewer, the text is written to the
QUERY_STATS_VW1 view and the SQL_TEXT_OVERFLOW_INDICATOR field is set to 0. If the
text is longer, the first 254 characters are written to QUERY_STATS_VW1 and
SQL_TEXT_OVERFLOW_INDICATOR
is set to 1, indicating that the complete SQL text is found
in the SQL_TEXT field of SQL_TEXT_VW1. In SQL_TEXT_VW1, each row of SQL text can contain
up to 16000 characters. If the complete query text is written across multiple rows,
FRAGMENT_NUMBER
is incremented for each row, starting with 0.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for SQL_TEXT_VW1 field definition is QUERY_ID and FRAGMENT_NUMBER.
Table 3-2 SQL_TEXT_VW1 Field Definitions
Description Data Type Field Name
Primary Key
ANSI timestamp, in Local Civil Time,
indicating when query execution began
(that is, the time when an execute
statement is issued for the prepared
query).
Example: 2010–02–02 07:47:28.795392
TIMESTAMP(6) NO DEFAULT EXEC_START_LCT_TS
Primary Key
ANSI timestamp, in Coordinated
Universal Time, indicating when query
execution began.
Example: 2010–02–02 15:47:28.795392
TIMESTAMP(6) NO DEFAULT EXEC_START_UTC_TS
Primary Key
A unique identifier for this SQL
statement, generated by Neoview SQL
compiler.
CHAR(160) NO DEFAULT QUERY_ID
Primary Key
Number of the row for a section of
query text, starting with zero (0). 16000
characters of query text are written per
row.
SMALLINT UNSIGNED NO
DEFAULT FRAGMENT_NUMBER
Name of the Neoview platform segment
used by the datasource to connect and
start the query. The Master Executor
process for the query is running in this
segment. CHAR(16) DEFAULT NULL SEGMENT_NAME
32 Repository Views