SQL/MP Messages Manual

SQL Compiler Optimizer Messages (6000 to 6999)
HP NonStop SQL/MP Messages Manual—427720-006
8-5
SQL 6016
Cause. The optimizer attempted to sort a table on another node, and tried to choose a
disk on the current node to hold the result of the sort. It can choose only an audited
disk that is not $SYSTEM. No such disk exists on the current node.
Effect. The statement does not compile.
Recovery. Add an audited volume to the current node, or run this query from a node
that has an audited volume.
SQL 6018
Cause. This join method is not implemented.
Effect. The CONTROL statement has no effect.
Recovery. Do not specify this join method.
SQL 6019
Cause. The CONTROL TABLE directives specified a join method that cannot be used
with this query.
Effect. The statement fails.
Recovery. Use CONTROL TABLE * JOIN METHOD SYSTEM. Remove the
CONTROL TABLE directives specifying JOIN METHOD MERGE or HASH.
6016 The current query requires one or more sorts, and no
suitable disk volume exists to store the result of a sort on
the current system.
6018 The HASH join method has not yet been implemented in
this version. Wait for a future version or release.
6019 The CONTROL TABLE directives specified a MERGE or HASH
join in a case where there was no appropriate join predicate.