SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-10
Operations on Catalog Tables
that contain statistics are updated only when you issue an UPDATE STATISTICS
command.)
You can also use these statements with catalog tables:
You cannot use other SQL statements on catalog tables. For example, you cannot
create indexes or constraints on catalog tables or drop individual tables within the
catalog.
DML: DECLARE CURSOR
FETCH
SELECT
DCL: CONTROL EXECUTOR
CONTROL QUERY
CONTROL TABLE (has no effect)
FREE RESOURCES
LOCK TABLE (not recommended)
DDL: ALTER CATALOG (security only)
ALTER TABLE (security only for CATALOGS, PROGRAMS, TRANSIDS, or
USAGES tables)
COMMENT
CREATE CATALOG
CREATE VIEW (shorthand views only)
DROP CATALOG
UPDATE STATISTICS
Other: INVOKE
DISPLAY USE OF
VERIFY
Caution. Normally, DELETE, INSERT, and UPDATE statements do not work on catalog
tables, but a licensed SQLCI2 process (or a licensed SQL program file) can use any DML
operation on catalog tables, as described in the SQL/MP Installation and Management Guide.
Only the most extreme situations should require the use of a licensed SQLCI2 process,
because such operations can be extremely dangerous to the consistency of the database and
the data dictionary.