SQL/MP Programming Manual for COBOL85

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
6-6
Using DEFINEs in the OSS Environment
description of the STOREDDEFINES option, see SQL Compiler Options on
page 6-26.
Using DEFINEs in the OSS Environment
Use these HP 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 as follows:
•
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 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 utility, add the DEFINE before
you issue the cobol 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 commands create a class MAP DEFINE and a class CATALOG
DEFINE:
add_define =emptab class=map file=\\ny.\$disk2.fy94.empfile
add_define =sqlcat class=catalog subvol=\$sql.sqlcat
•
System names or the names of volumes where OSS objects reside must be seven
characters or fewer.
•
To alter an existing DEFINE, use the add_define utility and specify all DEFINE
attributes and their new values. In this situation, the add_define utility essentially
adds a new DEFINE with the same name in place of the old DEFINE.
OSS Utility Description
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 Shows the values for one or more DEFINE attributes in the
current working attribute set