SQL/MP Messages Manual

SQL Compiler Normalizer Messages (5000 to 5999)
HP NonStop SQL/MP Messages Manual—427720-006
7-8
SQL 5029
Cause. The SQL compiler does not allow an outer join on a shorthand view whose
definition also contains an outer join operation.
Effect. The statement does not compile.
Recovery. Remove the unsupported operation from the query.
SQL 5030
Cause. The SQL compiler supports outer join formulations of the following type:
tablename [INNER / LEFT] JOIN tablename ON search-condition.
In the join specification, tablename is the name of a table or a view.
Effect. The statement does not compile.
Recovery. Refer to the SQL/MP Reference Manual and reformulate your query.
SQL 5031
Cause. The occurrence of an aggregate function is appropriate in a search condition
only in the HAVING clause of a grouped SELECT statement.
Effect. The statement does not compile.
Recovery. Remove the search condition containing the aggregate function and
reformulate your query.
5029 A shorthand view whose definition contains an outer join
operation cannot participate in an outer join with another
table or view.
5030 The outer join formulation specified in this query is
not supported by the version of NonStop SQL/MP that you are
using. The only item that can appear between LEFT JOIN and
its ON clause is a table or a view that involves only one
table.
5031 An aggregate function should not appear in the search
condition associated with an ON clause of an outer join
operation or in the WHERE clause of a SELECT statement that
is not grouped.