SQL/MP Messages Manual

SQL Compiler Normalizer Messages (5000 to 5999)
HP NonStop SQL/MP Messages Manual—427720-006
7-6
SQL 5022
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
SQL 5023
Cause. Only a function with an argument that is a correlated reference to a column
from an outer query is allowed.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
SQL 5024
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
SQL 5025
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
5022 If a SELECT statement refers to a grouped view in the
FROM clause, the SELECT statement cannot include any function
on columns of that view in the select list.
5023 If a GROUP BY list refers to a select list item, that
select list item cannot be an aggregate function with an
argument that contains a column from the FROM clause result
table.
5024 If the argument of an aggregate function contains a
column from a subquery and a correlation column from a SELECT
statement that is a grouped query, the correlation column
must be a grouping column of the SELECT statement.
5025 For a grouped SELECT statement, an expression cannot
contain both an aggregate function whose argument contains a
column from the select statement and a column that is not a
grouping column of the select statement.