SQL Supplement for H-Series RVUs

SQL/MP Programming Manual for COBOL
HP NonStop SQL Supplement for H-Series RVUs—529446-005
1-47
Running the SQL Compiler
•
Uncompiled SQL statements with empty sections. The SQL compiler
generates an empty section if an SQL statement references a nonexistent
DEFINE or SQL object.
Other SQL statements retain their existing execution plans.
The COMPILE INVALID PLANS option stores similarity information in the
program file and updates the program’s dependencies on database objects in
the USAGES tables.
If the program has not been previously compiled or if the program does not
contain similarity information, the COMPILE INVALID PLANS option directs the
SQL compiler to compile all SQL statements in the program.
INOPERABLE PLANS
directs the SQL compiler to explicitly compile these SQL statements:
•
Statements with inoperable plans (invalid plans that fail the similarity
check).
•
Uncompiled statements with empty sections. The SQL compiler generates
an empty section if an SQL statement references a nonexistent DEFINE or
SQL object. (The SQL compiler also generates empty sections for
CONTROL directives and DDL statements.)
Other SQL statements retain their existing execution plans.
The COMPILE INOPERABLE PLANS option stores similarity information in the
program file and updates the program’s name map and usages in the
USAGES tables.
If the program has not been previously compiled or if the program does not
contain similarity information, the COMPILE INOPERABLE PLANS option
directs the SQL compiler to compile all SQL statements in the program.
To terminate a compilation in the Guardian environment, use the Break key to return to
the Command Interpreter and stop the process using its process identification number.
Running the SQL Compiler in the OSS Environment
In an OSS environment, the SQL compiler is invoked by the cobol utility (on a TNS/R
system) with the -Wsql flag or by the nmcobol or ecobol utility with the -Wsql or
-Wsqlcomp flag. For more information, see Running HP COBOL Compilers in the
OSS Environment on page 1-24 or the Open System Services Shell and Utilities
Reference Manual.