SQL/MP Messages Manual

SQL Compiler Normalizer Messages (5000 to 5999)
HP NonStop SQL/MP Messages Manual—427720-006
7-7
SQL 5026
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
SQL 5027
Cause. The specified use of row-value-specification is not supported.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
SQL 5028
Cause. The SQL compiler does not support the operations listed in the error message
for a shorthand view whose definition contains a UNION operator.
Effect. The statement does not compile.
Recovery. Remove the unsupported operation from the query.
5026 For a SELECT DISTINCT statement, the ORDER BY list can
refer only to columns that appear in the select list.
5027 row-value-specification is NOT supported in the
following constructs,
row-value-specification IN in-value-list
row-value-specification IN subquery
row-value-specification comparison-op SOME|ALL|ANY
subquery
row-value-specification IS NULL.
5028 A view whose definition contains a UNION of SELECT
statements cannot be involved in a join or a GROUP BY, nor
can an aggregate function be applied to any of its columns.