Pathmaker Reference Manual

SERVICE Statement
Pathmaker Application Definition Language (PMADL)
2–58 067869 Tandem Computers Incorporated
SORT
Specifies the order of retrieval for the rows:
ASCENDING Specifies that the rows are to be retrieved in the
order implied by the access path columns. This
is the default value.
DESCENDING Specifies that the rows are to be retrieved in the
reverse of the order implied by the access path
columns.
POSITION-MODE
Specifies which rows are to be retrieved from the table as a function
of a specified sequence of values in their access path columns:
EXACT Specifies that only the rows which equal the
access path values are to be retrieved.
APPROXIMATE Specifies that only the rows which equal or
follow the access path values are to be retrieved.
COMPLETE Specifies that all rows are to be retrieved,
regardless of their access path values. This is the
default value.
START
Specifies the row that the operation is to retrieve.
FIRST Specifies the first qualifying row in the table.
This is the default value.
CURRENT Specifies the first qualifying row at or following
the current primary key value.
NEXT Specifies the first qualifying row strictly
following the current primary key value.
FOR-UPDATE
Specifies operations that can be used to modify records retrieved via
the primary operations generated using FETCH.
YES Specifies that SQL UPDATE-AT-CURSOR and
DELETE-AT-CURSOR operations are to be
generated in the operation paragraph.
NO Specifies that these operations are not to be
generated. This is the default value.