SQL/MP Messages Manual

SQL Compiler Normalizer Messages (5000 to 5999)
HP NonStop SQL/MP Messages Manual—427720-006
7-10
SQL 5034
Cause. The ORDER BY clause for a union of SELECT statements included a column
name that occurred more than once in the select list of the first SELECT statement.
The SQL compiler cannot decide which instance of the column name to use for
ordering rows, and the compiler cannot resolve the position of the ordering column in
the first select list.
Effect. The statement does not compile.
Recovery. Instead of specifying the column name, specify a number that indicates the
position of the column in the select list of the first SELECT statement.
SQL 5100
Cause. Internal error: Either the compiler was in an unexpected state, or the compiler
detected an inconsistency in the data structures it was manipulating.
Effect. The statement does not compile.
Recovery. None. Report the entire message to your service provider.
SQL 5101
Cause. An internal structure or variable reached the limit of its capacity. The query is
too large or complex.
Effect. The statement does not compile.
Recovery. Simplify the query or divide it into smaller steps. If the query uses a
shorthand view, consider whether the view definition can be simplified.
5034 The ORDER BY clause for a union of SELECT statements can
only reference a column from the select list of the first
SELECT statement. If the same column name appears more than
once in that select list, then the SQL compiler cannot decide
which instance of the column to use for ordering rows; the
column references are ambiguous.
5100 Internal error: Detected by the SQL compiler
normalizer.
5101 Statement size and complexity are beyond the capacity of
the present version of the SQL compiler normalizer.