SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-25
ALTER TRIGGER Statement
ALTER TRIGGER Statement
Considerations for ALTER TRIGGER
The ALTER TRIGGER statement is used to enable or disable triggers, individually or
by SQL/MX table.
Syntax Description of ALTER TRIGGER
trigger-name
specifies the ANSI logical name of the trigger to be altered, of the form:
[[catalog-name.]schema-name.]trigger-name
where each part of the name is a valid SQL identifier with a maximum of 128
characters. For more information, see Identifiers on page 6-53.
table-name
specifies the ANSI logical name of the table that this trigger is defined on, of the
form:
[[catalog-name.]schema-name.]table-name
where each part of the name is a valid SQL identifier with a maximum of 128
characters.
Considerations for ALTER TRIGGER
ENABLE ALL enables all triggers defined on table-name.
DISABLE ALL disables all triggers defined on table-name.
Authorization and Availability Requirements
To alter a trigger, you must own its schema or be the super ID. Only the super ID can
use ALTER TRIGGER DISABLE ALL or ALTER TRIGGER ENABLE ALL.
BEGIN WORK Statement
The BEGIN WORK statement enables you to start a transaction explicitly—where the
transaction consists of the set of operations defined by the sequence of SQL
statements that begins immediately after BEGIN WORK and ends with the next
COMMIT or ROLLBACK statement. See Transaction Management on page 1-12.
ALTER TRIGGER { ENABLE trigger-name |
ENABLE ALL OF table-name |
DISABLE trigger-name |
DISABLE ALL OF table-name};