SQL Supplement for H-Series RVUs

SQL/MP Programming Manual for COBOL
HP NonStop SQL Supplement for H-Series RVUs—529446-005
1-39
Running the SQL Compiler
For example, if a program refers to a collation, SQLCOMP generates a row in the
USAGES table showing that the program depends on the collation and sets
USAGES.USEDOBJTYPE to CP.
•
Generates a listing of the SQL statements in the program file, including warning or
error messages that occur.
•
Sets the SQL SENSITIVE and SQL VALID flags in the program file label if the
compilation is successful.
Running the SQL Compiler in the Guardian Environment
To run the SQL compiler in the Guardian environment, enter the SQLCOMP command
at the TACL prompt or from a TACL OBEY command file using this syntax:
SQLCOMP / IN object-file [ , OUT [ list-file ] ]
[ , run-option] [ , run-option ]... /
[ compiler-option [ , compiler-option ]... ]
compiler-option is:
[ CATALOG catalog-name ]
[ CURRENTDEFINES | STOREDDEFINES ]
[ EXPLAIN ]
[ [ PLAN ] ]
[ [ DEFINES [ file-name ] [, OBEYFORM ] ] ]
[ ]
[ NOEXPLAIN ]
[ FORCE | NOFORCE ]
[ OBJECT | NOOBJECT ]
[ RECOMPILE | NORECOMPILE ]
[ RECOMPILEONDEMAND | RECOMPILEALL ]
[ REGISTERONLY { ON | OFF } ]
[ NOREGISTER { ON | OFF } ]
[ CHECK { INVALID PROGRAM }
{ INVALID PLANS }
{ INOPERABLE PLANS } ]
[ COMPILE { PROGRAM [ STORE SIMILARITY INFO ] }
{ INVALID PLANS }
{ INOPERABLE PLANS } ]