SQL/MP Messages Manual

SQL Compiler Optimizer Messages (6000 to 6999)
HP NonStop SQL/MP Messages Manual—427720-006
8-6
SQL 6020
Cause. The CONTROL TABLE directives specified join sequence values that cannot
be used with this query.
Effect. The statement fails.
Recovery. Use CONTROL TABLE * JOIN SEQUENCE SYSTEM. Remove the
CONTROL TABLE directives specifying JOIN SEQUENCE.
SQL 6021
Cause. The CONTROL TABLE directives specified join sequence values that cannot
be used with this query.
Effect. The statement fails.
Recovery. Use CONTROL TABLE * JOIN SEQUENCE SYSTEM. Remove the
CONTROL TABLE directives specifying JOIN SEQUENCE.
SQL 6022
Cause. The ACCESS PATH option specified an index that did not exist, did not belong
to the table, or did not contain valid data.
Effect. The statement is left uncompiled until an attempt is made to recompile it or
execute it. If the message is a warning at compile time, the access path must be valid
before the statement executes.
Recovery. Access to the table or view is affected by a CONTROL TABLE directive
with the ACCESS PATH option. This option prevents access through any index other
than the one specified. Create the required index, or correct or remove the CONTROL
TABLE directive specifying ACCESS PATH. Use the CONTROL TABLE * ACCESS
PATH SYSTEM to direct SQL to choose the access path.
6020 The CONTROL TABLE directives specified a set of JOIN
SEQUENCE values that are not consistent with the query.
6021 The CONTROL TABLE directives specified a set of JOIN
SEQUENCE values that are inconsistent with the outer join
semantics of this query.
6022 Table or view value-1 cannot be accessed because a
CONTROL TABLE directive specifies an access path value-2 that
does not exist, does not belong to this table, or does not
contain valid data.