SQL/MP Messages Manual

HP NonStop SQL/MP Messages Manual—427720-006
7-1
7
SQL Compiler Normalizer Messages
(5000 to 5999)
SQL 5001
Cause. An aggregate function cannot have an aggregate function as an argument.
For example, MAX(AVG (salary)) is invalid.
Effect. The statement does not compile.
Recovery. Correct the argument and recompile.
SQL 5002
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the cursor definition if you want to use it for update operations, or
correct the program in some other way, and recompile.
SQL 5003
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the subquery select list and recompile.
5001 Aggregate function in argument of aggregate function.
5002 Cursor could not be used for update because of one of
these reasons: 1) It involves a join. 2) It has a GROUP BY
clause, ORDER BY clause, or aggregate functions. 3) It
specifies DISTINCT.
5003 A subquery can have only one entry in the select list.