SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-6
SQL 8026
Cause. Either the program was marked invalid or the run time DEFINEs were different
than the compile time DEFINEs, and the program was SQL compiled with the
NORECOMPILE option.
Effect. The program fails.
Recovery. SQL compile and rerun the program.
SQL 8027
Cause. One or both of the following causes for automatic recompilation of SQL
statements could be present:
•
A DDL operation altered the definition of an object that is used by the statement, or
•
An attempt was made to recompile the statement to access the required data
through another access path (due to unavailability of the access path that was
chosen at SQL compile time).
Effect. The statement fails.
Recovery. SQL compile and rerun the program.
SQL 8028
Cause. Stated in the error message.
Effect. The statement fails. Recompilation is not attempted again because repeated
attempts to recompile would impact performance. In cases where only some partitions
of a table are unavailable, the statement can still be used to access the available
partitions.
Recovery. Recompilation typically fails because of the unavailability of a table or a
catalog. Wait for the unavailable object or objects to become available again. If the
error persists, restart the program. For dynamic SQL, prepare the statement again.
8026 Your SQL program needed to be recompiled but had the
NORECOMPILE option set.
8027 The SQL statement needed to be recompiled but the
program had the NORECOMPILE option set.
8028 Because a previous recompilation of the statement
failed, recompilation will not be tried again.