Pathmaker Reference Manual

SERVICE Statement
Pathmaker Application Definition Language (PMADL)
2–56 067869 Tandem Computers Incorporated
NONE Specifies that the paragraph is not to verify the
row. This is the default value if a BEFORE-
IMAGE clause is not supplied in the logical file
definition.
SELECT
Specifies an SQL SELECT operation to retrieve a row from the table to be
generated in the operation paragraphs. The row is identified by the
unique values it has in the access path columns.
GENERATE
Specifies whether to generate the operation.
YES Specifies that the operation be generated.
NO Specifies that the operation not be generated.
If you do not specify the GENERATE attribute, the operation is
generated; that is, the effect is the same as specifying the GENERATE
attribute with YES. If you omit the entire SELECT clause, the
operation is not generated, that is the effect is the same as specifying
the GENERATE attribute with NO.
ACCESS-TYPE
Specifies access to the rows.
BROWSE Specifies that the retrieved or modified rows are
not to be locked.
STABLE Specifies that the rows are to be locked for the
duration of the SQL operation. This is the
default value.
REPEATABLE Specifies that the rows are to be locked until
explicitly released by the application.
LOCK-MODE
Specifies access to the retrieval operation.
SHARED Specifies that the retrieval operation is to permit
concurrent access to the table by other processes.
This is the default value.
EXCLUSIVE Specifies that the operation is not to permit
concurrent access to the table.