Pathmaker Reference Manual

SQL Operation Attributes Screen
Pathmaker Screens
067869 Tandem Computers Incorporated 1–179
SQL IO Section Name
Displays the section name in the procedure division code generated for the selected
SQL operations, as transferred from the SQL Operations screen. You cannot enter data
into this field.
Gen: Select
Enter X (or any other non-blank value) to specify the SELECT attribute. A non-blank
in this field indicates that code is to be generated for the named operation. The
attribute values displayed to the right of SELECT are meaningful only if SELECT is
marked.
Access Type
Enter a value to indicate the SQL locking access type for the SELECT operation.
B Browse
S Stable (default)
R Repeatable
Lock Mode
Enter a value to indicate the SQL locking mode for the SELECT operation.
S Shared (default)
E Exclusive
If the access type is browse, the lock mode is ignored.
Gen: Fetch
Enter X (or any other non-blank value) to specify the FETCH attribute. A non-blank in
this field indicates that code is to be generated for the named operation. The attribute
values displayed to the right of FETCH are meaningful only if FETCH is marked.
Sort Direction
Enter a value to indicate the order in which rows are accessed with respect to the
values in the Access Path columns in the host variable record.
A Ascending (default)
D Descending
Position Mode
Enter a value to identify the subset of rows that are accessible by the FETCH
operation, as a function of the values in the Access Path columns of the host variable
record.
E Exact
A Approximate
T All rows of the table (default)