SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-8
Trigger Statements
Trigger Statements
Use these statements to create and manipulate triggers on SQL/MX tables:
Utilities
Use these utilities to transform metadata, duplicate tables, partition management, load
indexes, purge and recover data from the database objects:
ALTER TRIGGER Statement on
page 2-48
Alters a trigger.
CREATE TRIGGER Statement
on
page 2-143
Creates a trigger.
DROP TRIGGER Statement
on
page 2-191
Drops a trigger.
SET Statement
on page 2-364 Controls the action of a BEFORE trigger.
SIGNAL SQLSTATE Statement
on
page 2-380
Enables a trigger execution to raise an exception that
causes both the triggered and triggering statements
to fail.
DOWNGRADE Utility on
page 2-174
Transforms metadata from the existing version to
a specified, lower version.
DUP Utility on page 2-193 Duplicates SQL/MX tables.
FASTCOPY Utility on page 2-225 Copies rows from one table or index into an
existing compatible table or index.
MODIFY Utility on page 2-270 Performs partition management operations and
Guardian rename operations on tables or
indexes.
POPULATE INDEX Utility
on
page 2-303
Loads indexes.
PURGEDATA Utility on
page 2-306
Purges data from tables, indexes, or partitions.
RECOVER Utility
on page 2-310 Determines the state of a failed utility operation
and restores recoverable objects. Also, recovers
a schema from a failed change of ownership
operation. For more information, see RECOVER
SCHEMA Operation.
UPGRADE Utility on page 2-411 Transforms metadata from the existing version to
the current schema version for the SQL/MX
Software Version (MXV).