SQL/MP Messages Manual

SQL Compiler Normalizer Messages (5000 to 5999)
HP NonStop SQL/MP Messages Manual—427720-006
7-5
SQL 5018
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the subquery select list and recompile.
SQL 5019
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
SQL 5020
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile. If you use GROUP BY or ORDER BY
for a view column, make sure you specify that view column in the select list.
Alternatively, contact your database administrator about the view definition.
SQL 5021
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
5018 A subquery select list must contain only one expression.
5019 A SELECT statement that is grouped cannot refer to a
view that is grouped.
5020 A SELECT statement refers to a view that cannot be
composed. If the GROUP BY or ORDER BY list of a statement
indexes a view column that is an expression, the view column
must be specified in the select list of the statement. The
view column in the select list must appear alone as one of
the entries and not in an expression.
5021 If a SELECT statement has a HAVING clause, the SELECT
statement cannot refer to a grouped view in the FROM clause.