SQL/MP Messages Manual

HP NonStop SQL/MP Messages Manual—427720-006
8-1
8
SQL Compiler Optimizer Messages
(6000 to 6999)
SQL 6001
Cause. You specified the same column more than once in the list of columns to be
updated.
Effect. The statement does not compile.
Recovery. Remove the duplicate column, and reissue the statement.
SQL 6002
Cause. You cannot have more than 16 levels of query nesting specified in a query.
Effect. The statement does not compile.
Recovery. Check that the query contains no more than 16 levels of nesting, and
reissue the statement.
SQL 6003
Cause. You cannot have the ALLPLANS option of EXPLAIN specified in a query
containing subquery.
Effect. The statement fails.
Recovery. Remove the ALLPLANS option from the query, and reissue the statement.
6001 Duplicate column in the update list.
6002 More than 16 levels of nesting have been specified in a
query.
6003 A query must not contain any subquery if the ALLPLANS
option of EXPLAIN has been specified.