HP Neoview Release 2.5 Software - Manual (Page 73)

B STATEMENT_TYPE Field
The following table provides the compiler-provided values for the STATEMENT_TYPE field of
the NEO.HP_METRICS.ODBC_QUERY_STATS_VW2 Repository view.
Statements/Commands Compiler-Provided Value
SELECT, TABLE SQL_SELECT_UNIQUE
SELECT, TABLE, EXPLAIN SQL_SELECT_NON_UNIQUE
INSERT, VALUES SQL_INSERT_UNIQUE
INSERT, VALUES SQL_INSERT_NON_UNIQUE
UPDATING A UNIQUE ROW, MERGE_INTO SQL_UPDATE_UNIQUE
UPDATE SQL_UPDATE_NON_UNIQUE
DELETE SQL_DELETE_UNIQUE
DELETE SQL_DELETE_NON_UNIQUE
CONTROL QUERY DEFAULT SQL_CONTROL
SET TRANSACTION SQL_SET_TRANSACTION
SET SCHEMA SQL_SET_SCHEMA
ALTER/CREATE/DROP SYNONYM
ALTER/CREATE/DROP TABLE
ALTER/CREATE/DROP MATERIALIZED VIEW
ALTER/CREATE/DROP VIEW
ALTER/CREATE/DROP MVGROUP
ALTER/CREATE/DROP TRIGGER
CREATE/DROP INDEX
CREATE/DROP SCHEMA
GRANT/REVOKE
GRANT/REVOKE SCHEMA
GRANT/REVOKE EXECUTE
ROLLBACK WORK
BEGIN WORK
COMMIT WORK SQL_OTHER
CALL SQL_CALL_NO_RESULT_SETS
CALL (Statements that execute stored procedure returning
result sets) SQL_CALL_WITH_RESULT_SETS
UPDATE STATISTICS, REFRESH, Utility commands that
are implemented as internal stored procedures SQL_CAT_UTIL
MAINTAIN, REPLICATE, PURGEDATA SQL_EXE_UTIL
Insert using user load command SQL_EXEC_INSERT_RWRS
73