SQL/MX 2.x Messages Manual (H06.04+)

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Messages Manual—540498-003
12-9
Recovery. If possible, drop the trigger first, and then drop the object. You can use the
cascade option to drop the object, but you risk dropping all objects that use that object,
including the triggers.
SQL 11034
Where table-name is the table name you are attempting to drop.
Cause. You attempted a “drop table cascade” on a table that contains defined triggers.
Effect. The operation succeeds.
Recovery. None. This is a warning only.
SQL 11035
Cause. You attempted to create a trigger on a metadata table.
Effect. The operation fails.
Recovery. None.
SQL 11036
Where table-name is the name of the specified table.
Cause. You attempted to “alter trigger enable/disable all of” on a table that does not
have triggers.
Effect. This is a warning only. The operation succeeds.
Recovery. None.
SQL 11037
Cause. You attempted to create a trigger on a view.
Effect. The operation fails.
Recovery. Abandon the operation or create a trigger on one of the view-based tables,
if this is applicable to your application.
11034 Triggers Temporary Table existed for table table-name.
11035 Metadata tables cannot have triggers!
11036 No triggers are defined on table table-name.
11037 A trigger cannot be defined on a view!