Pathmaker Reference Manual

SERVICE Statement
Pathmaker Application Definition Language (PMADL)
067869 Tandem Computers Incorporated 2–57
FETCH
Specifies that SQL OPEN-CURSOR, FETCH-CURSOR, and
CLOSE-CURSOR operations for the table are to be generated in the
operation paragraphs. You use these operations to retrieve a series of
rows from the table.
The rows are identified and ordered by the values they have in the access
path columns, in conjunction with the following subclauses of the FETCH
clause:
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 FETCH 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.