SQL/MP Messages Manual

SQL Compiler Messages
HP NonStop SQL/MP Messages Manual—427720-006
4-24
SQL 2062
Cause. The STOREDDEFINES option is specified while SQL compiling a program
that have not been SQL compiled previously.
Effect. The SQL compilation terminates.
Recovery. Remove the option and recompile.
SQL 2063
Cause. The SQLCOMP command includes an incomplete compiler option EXPLAIN
TOKENIZED.
Effect. The SQL compilation terminates abnormally.
Recovery. Add a file name to the EXPLAIN TOKENIZED option.
The following messages for High Availability Compilation (HAC) can appear in the SQL
compiler listing when you compile a program using COMPILE INVALID PLANS or
COMPILE INOPERABLE PLANS. The SQL compiler displays the messages to
indicate why it recompiled or did not recompile a statement. The messages are not
errors or warnings.
SQL 2133
Cause. No recompilation was performed because the plan is valid.
Effect. None.
Recovery. Informational message only; no corrective action is needed.
SQL 2134
Cause. No recompilation was performed because the plan is operable.
Effect. None.
Recovery. Informational message only; no corrective action is needed.
2062 The SQL-COMPILER option STOREDDEFINES applies only to
programs that have been SQL compiled previously.
2063 The EXPLAIN TOKENIZED option must be followed by a file
name.
2133 Skipped recompilation because the plan is valid.
2134 Skipped recompilation because the plan is operable.