SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-17
SQL 8208
Cause. Stated in the error message.
Effect. The first execution of an SQL statement in the program is delayed while an
SQLCOMP process is started to recompile the program. An EMS message is created
to record this event. No warning or error is returned to the SQLCA.
Recovery. To avoid future recompilations, consider performing a static SQL
compilation using the new DEFINEs.
SQL 8209
Cause. The program was invalidated by a DDL operation. See the PROGRAMS and
USAGES catalog tables for the current state of the program and information about its
dependencies.
Effect. The first execution of an SQL statement in the program is delayed while an
SQLCOMP process is started to recompile the program. An EMS message is created
to record this event. No warning or error is returned to the SQLCA.
Recovery. Perform a static SQL compilation on the program file.
SQL 8210
Cause. Possible causes include a statement that produced a warning during a static
SQL compilation, or execution of a statement that could not be recompiled during
dynamic program recompilation.
Effect. Statement recompilation is attempted.
Recovery. In most cases, static SQL compilation of the program resolves this
problem. Some applications are written in a way that this warning always occurs when
the program is run. For example, a program that creates a table and then performs a
DML operation on it will receive this error.
8208 The program was dynamically recompiled because it was
started with a set of DEFINEs that is different from the
DEFINEs used at SQL compilation time.
8209 The program was dynamically recompiled because it was
invalid.
8210 The statement was recompiled because the program did not
contain a compiled object for it.