EasyManua.ls Logo

HP NonStop SQL/MX - Page 651

HP NonStop SQL/MX
752 pages
Print Icon
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
Rowsets Messages (30000 through 30999)
HP NonStop SQL/MX Messages Manual—640324-001
20-5
SQL 30026
Where,
index-name is the name of the dependent index.
table-name is the name of the table containing the dependent index.
Cause. You attempted to use NOT ATOMIC inserts on a table that has at least one
dependent index. Dependent indexes might have been created by the system to
enforce a uniqueness or primary key constraint.
Effect. The operation fails.
Recovery. Do not attempt recovery. Contact your service provider.
SQL 30027
Where,
trigger-name is the name of the BEFORE trigger.
table-name is the name of the subject table.
Cause. You attempted to use NOT ATOMIC inserts on a table that is the subject table
of at least one BEFORE trigger.
Effect. The operation fails.
Recovery. Contact your service provider.
SQL 30028
Where,
constraint-name is the name of the referential integrity constraint.
table-name is the name of the referencing table.
30026 NOT ATOMIC rowset INSERT is not supported on a table
that has dependent indexes that are not offline. Dependent
index index-name exists for table table-name.
30027 NOT ATOMIC INSERT is not supported on a table that is
the subject table of BEFORE triggers. BEFORE trigger trigger-
name has table table-name as its subject table.
30028 NOT ATOMIC INSERT is not supported on a table that is
the referencing table of referential integrity constraints.
Referential integrity constraint constraint-name has table
table-name as its referencing table.