Server Error Messages 1000-1099 814
1007 16 Abstract Plan (AP) : The AP expression describes a bushy join tree, while the Server only
supports left deep join trees. The bushy right join operand will not be applied. Check the
AP syntax.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1008 16 Abstract Plan (AP) : The SQL query step does not contain a subquery to match the
subquery %d described in the AP. The subquery will be ignored. Check the AP syntax and
its correspondence to the query.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1009 16 Abstract Plan (AP) : The SQL query step does not contain a base table to ma tch the base
table ’%.*s’ described in the AP. The base table will be ignored. Check the AP syntax and
its correspondence to the query.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1010 16 Abstract Plan (AP) : The SQL query step does not contain a work table to match the work
table ’%.*s’ described in the AP. The work table will be ignored. Check the AP syntax
and its correspondence to the query.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1011 16 Abstract Plan (AP) : The AP expression uses the work table ’%.*s’, but does not define
it through a STORE operator. The table will be ignored. Check the AP syntax.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1012 16 Abstract Plan (AP) : The AP expression describes the materialization of a join, while the
Server only supports single table reformatting. The operand of the STORE operator will
be ignored. Check the AP syntax.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1013 16 Abstract Plan (AP) : %s; line %d, occurring near ’%.*s’. Check the AP syntax.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1014 16 Abstract Plan (AP) : The correlation name ’%.*s’ is used in the AP expression for the
table ’%.*s’ and in the SQL query for the table ’%.*s’. The table will be ignored. Check
the AP syntax and its correspondence to the query.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1015 16 Abstract Plan (AP) : You cannot use a variable of type %s. Use CHAR, VARCHAR or
TEXT instead.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
Number Severity Text and Explanation