![HP NonStop SQL/MX Messages Manual Download Page 651](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150651.webp)
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.
Summary of Contents for NonStop SQL/MX
Page 4: ......
Page 8: ...Contents HP NonStop SQL MX Messages Manual 640324 001 iv ...
Page 26: ...General Messages 0 through 999 HP NonStop SQL MX Messages Manual 640324 001 2 2 ...
Page 130: ...SQL MX MXCMP Messages 2000 through 2999 HP NonStop SQL MX Messages Manual 640324 001 4 34 ...
Page 242: ...Normalizer Messages 5000 through 5999 HP NonStop SQL MX Messages Manual 640324 001 7 2 ...
Page 246: ...Optimizer Messages 6000 through 6999 HP NonStop SQL MX Messages Manual 640324 001 8 4 ...
Page 248: ...Generator Messages 7000 through 7999 HP NonStop SQL MX Messages Manual 640324 001 9 2 ...
Page 614: ...Utility Messages 20000 through 23099 HP NonStop SQL MX Messages Manual 640324 001 18 138 ...
Page 752: ...Non SQLCODE Error Messages HP NonStop SQL MX Messages Manual 640324 001 A 14 MXGNAMES Utility ...