SQL/MP Messages Manual

SQL Compiler Optimizer Messages (6000 to 6999)
HP NonStop SQL/MP Messages Manual—427720-006
8-7
SQL 6023
Cause. The CONTROL TABLE directives specified an index that cannot be used for
this update query.
Effect. The statement fails.
Recovery. Use CONTROL TABLE * ACCESS PATH SYSTEM.
SQL 6024
Cause. The CONTROL TABLE directive specified a join method that cannot be used
with the table.
Effect. The statement fails.
Recovery. Use CONTROL TABLE * JOIN METHOD SYSTEM. Remove the
CONTROL TABLE directive specifying JOIN METHOD KEY SEQUENCED MERGE.
SQL 6025
Cause. The CONTROL TABLE directive specified MDAM ON for a table with one of
the following conditions:
•
There were no usable key predicates for the ACCESS PATH specified for the table.
•
A protection view on the table was used.
•
A key-sequenced merge join and MDAM were both forced on the same table. The
table was not chosen as the outermost table in the join.
Effect. A warning is issued and the statement continues to compile and execute.
Recovery. Use the CONTROL TABLE directive with MDAM ON for a table that does
not violate the conditions specified as the cause of the failure.
6023 The CONTROL TABLE directives specified an access path
that would cause the "Halloween update" problem. This index
cannot be used for the update because it might cause rows to
be updated to incorrect values.
6024 The CONTROL TABLE directive specified a key-sequenced
merge join in a case where the outer and the inner tables
cannot be joined in the same order.
6025 The CONTROL TABLE directive specified MDAM ON for a
query in which MDAM could not be forced.