Hp Neoview Release 2.5 Software Bedienungsanleitung PDF herunterladen (Seite 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/CommandsCompiler-Provided Value

SELECT, TABLESQL_SELECT_UNIQUE

SELECT, TABLE, EXPLAINSQL_SELECT_NON_UNIQUE

INSERT, VALUESSQL_INSERT_UNIQUE

INSERT, VALUESSQL_INSERT_NON_UNIQUE

UPDATING A UNIQUE ROW, MERGE_INTOSQL_UPDATE_UNIQUE

UPDATESQL_UPDATE_NON_UNIQUE

DELETESQL_DELETE_UNIQUE

DELETESQL_DELETE_NON_UNIQUE

CONTROL QUERY DEFAULTSQL_CONTROL

SET TRANSACTIONSQL_SET_TRANSACTION

SET SCHEMASQL_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

CALLSQL_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, PURGEDATASQL_EXE_UTIL

Insert using user load commandSQL_EXEC_INSERT_RWRS

1 2 ... 68 69 70 71 72 73 74 75 76 77 78 ... 141 142

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 73