Pathmaker Reference Manual

SERVICE Statement
Pathmaker Application Definition Language (PMADL)
067869 Tandem Computers Incorporated 2–55
CONCURRENCY-CHECK
Specifies whether to verify the row.
ROW Specifies that the generated operation paragraph
is to verify that the modified row was not
changed since it was last read by the application.
This is the default value if a BEFORE-IMAGE
clause is supplied in the logical file definition.
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.
UPDATE
Specifies an SQL UPDATE 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 UPDATE 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.
CONCURRENCY-CHECK
Specifies whether to verify the row.
ROW Specifies that the generated operation paragraph
is to verify that the modified row was not
changed since it was last read by the application.
This is the default value if a BEFORE-IMAGE
clause is supplied in the logical file definition.