Pathmaker Reference Manual

SQL Operation Attributes Screen
Pathmaker Screens
1–180 067869 Tandem Computers Incorporated
Start Position
Enter a value to establish the starting position for a sequence of FETCH operations,
within the subset of rows identified by the Position Mode attribute.
F First (default)
C Current
N Next
Access Type
Enter a value to indicate the SQL locking access type for the FETCH operation.
B Browse
S Stable (default)
R Repeatable
Lock Mode
Enter a value to indicate the SQL locking mode for the FETCH operation.
S Shared (default)
E Exclusive
If the access type is browse, lock mode is ignored.
For Modification
Enter Y or N:
Y Generates the “where current of” clause for SQL updates and deletes.
N Does not generate that code. This is the default.
If the table is a shorthand view, do not enter a Y for this field. If the value in the Start
Position field is C or N, do not enter a Y for this field.
Access Path Name
Displays the Access Path name for the current entry on the SQL Operations screen.
Enter another name to change the access path. The change will also appear on the SQL
Operations screen when you return to that screen. The name must be an existing
access path for the current logical file.
Efficient
This is a display only field.
Y Specifies that an efficient index underlies the currently selected access path.
N Specifies that there is not such an index.