HP NonStop SQL/MX, Messages Manual

Page: 340 / 752

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Messages Manual — 640324-001
13 -10
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.
SQL 11038
Cause. You attempted to create a trigger on an object other than a user base table.
Effect. The operation fails.
Recovery. None.
SQL 11041
Cause. You attempted to create a trigger and one or more of the following conditions
are true:
•
The primary key length of the temporary table (which needs to be created when
the first trigger is created) is longer than the allowed maximum length.
•
The length of the temporary table name is longer than the maximum allowed user
table name length.
Effect. The operation fails.
Recovery. If the primary key length is too long, re-create your subject table with a
primary key that is 12 bytes shorter than the maximum allowed primary key length. If
the table name is too long, re-create your subject table with a name length that is six
characters shorter than the maximum allowed table name length.
SQL 11042
Where
name
is the name of the trigger you are trying to create.
Cause. You attempted to create a trigger that already exists.
11037 A trigger cannot be defined on a view!
11038 A trigger can be defined on base tables only!
11041 The calculated key length is greater than the allowed
limit of
max-key-length bytes.
11042 Trigger name already exists.