Pathmaker Reference Manual

SERVICE Statement
Pathmaker Application Definition Language (PMADL)
067869 Tandem Computers Incorporated 2–53
BEFORE-IMAGE name
Specifies the name of an SQL host variable to be defined in the service’s
generated source code. The variable is used in conjunction with the SQL
operations associated with the logical file, and is defined with the structure of
the logical file.
The name must be unique among the before-image host variable names of all
logical files defined in the service.
This clause is allowed only if the service is TYPE CUSTOM and LANGUAGE
COBOL, and if the logical file designates an SQL table.
SQL Operations Clause The following paragraphs give the term definitions for the SQL operations clause of
the service statement.
SQL-OPERATIONS name
Specifies the name of the source code section that contains a package of SQL
data manipulation operations to be generated as part of the source code of the
service. The operations provide services similar to the standard data
manipulation services available in TYPE DB requesters. Each operation is
generated as one or more paragraphs of source code in a common section.
SQL data manipulation operations can be defined only for logical files that
reference SQL tables.
This clause is allowed only if the service is TYPE CUSTOM and LANGUAGE
COBOL, and if the logical file designates an SQL table.
ACCESS-PATH name
Specifies the name of an access path used by the SQL operations. The
access path is an attribute of the logical file’s SQL table. The ACCESS-
PATH clause is required for the FETCH and SELECT operations.
MACRO name
Specifies the name of a registered macro to generate the SQL data
manipulation operations. The default macro name is COBOL -SQL-
OPERATIONS.
INSERT
Specifies an SQL INSERT operation for the table to be generated in the
operation paragraphs.
GENERATE
Specifies whether to generate the operation.
YES Specifies that the operation be generated.
NO Specifies that the operation not be generated.