SQL Supplement for H-Series RVUs

SQL/MP Programming Manual for COBOL
HP NonStop SQL Supplement for H-Series RVUs—529446-005
1-17
Preparing for Compilation
•
When you run the SQL compiler, you can specify a CLASS SPOOL DEFINE for
the OUT file and a class CATALOG DEFINE for the catalog option. If you use these
DEFINEs, add them before you enter the SQLCOMP command:
30> ADD DEFINE =persnl, CLASS CATALOG, SUBVOL persnl
31> ADD DEFINE =sqlist, CLASS SPOOL, LOC $S.#sqlist
32> SQLCOMP /IN sqlcbprg,OUT =sqlist,NOWAIT/ CATALOG =persnl
•
To use the DEFINEs stored in the program file when you explicitly recompile a
program, specify the STOREDDEFINES option of the SQLCOMP command. For a
description of the STOREDDEFINES option, see SQL Compiler Options on
page 1-41.
Using DEFINEs in the OSS Environment
Use these OSS utilities to create and manipulate class MAP and class CATALOG
TACL DEFINEs in the OSS environment:
Although you run these utilities in the OSS environment, each utility uses Guardian
conventions for its DEFINE attribute and the associated values. For a detailed
description, including the syntax of these utilities, see the Open System Services Shell
and Utilities Reference Manual.
Considerations for using TACL DEFINEs in the OSS environment are:
•
The add_define utility implicitly sets the DEFMODE attribute to ON before it
creates the new DEFINE.
•
Before you run the compiler using the cobol, nmcobol, or ecobol utility, add
these DEFINEs:
°
Class MAP DEFINEs specified in INVOKE directives
°
Class MAP or class CATALOG DEFINEs specified in SQL statements
•
If you specify a class CATALOG DEFINE for the SQLCOMP CATALOG option
when you run the SQL compiler using the cobol, nmcobol, or ecobol utility, add
the DEFINE before you issue the cobol, nmcobol, or ecobol command.
•
You must precede a backslash (\) in a system name or a dollar sign ($) in a catalog
or subvolume name with the OSS shell escape character (\). For example, these
add_define Creates a new class MAP, CATALOG, SPOOL, SORT,
SUBSORT, SEARCH, or TAPE DEFINE
del_define Deletes one or more DEFINEs
info_define Displays the attributes and values of existing DEFINEs
set_define Sets the values for one or more DEFINE attributes in the
current working attribute set
show_define Displays the values for one or more DEFINE attributes in the
current working attribute set