Pathmaker Reference Manual

SERVICE Statement
Pathmaker Application Definition Language (PMADL)
2–54 067869 Tandem Computers Incorporated
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 INSERT 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.
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.
DELETE
Specifies an SQL DELETE 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.
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 DELETE 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.
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.