SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual427720-006
9-16
SQL 7504
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.
SQL 7505
Cause. An internal temporary table requires a record size that will exceed its limit of
current version of SQL. The query may be too large or complex. Or, the query has too
many ORDER BY or GROUP BY columns.
Effect. The statement does not compile.
Recovery. Reformulate the query so that the record size for the temporary table would
be reduced in number to the acceptable limit.
SQL 7600
Cause. Internal error: The expression generator encountered an invalid data structure.
Effect. The statement does not compile.
Recovery. None. Report the entire message to your service provider.
7504 Statement size and complexity are beyond the capacity of
the present version of the SQL compiler generator.
7505 Record size for a temporary table required by a
DISTINCT, GROUP BY, ORDER BY, UNION, or join operation
exceeded its limit.
7600 Internal error: Expressions Generator.