Pathmaker Reference Manual

PM27—Pathmaker Service Logical File SQL Operations
Pathmaker Report Descriptions
D–10 067869 Tandem Computers Incorporated
Fetch Indicates attributes of the SQL OPEN-CURSOR, FETCH
operations.
Select Indicates attributes of the SQL SELECT operation.
Insert Indicates attributes of the SQL INSERT operation.
Update Indicates attributes of the SQL UPDATE operation.
Delete Indicates attributes of the SQL DELETE operation and
CLOSE-CURSOR operations.
Gen Indicates whether an operation is to be generated as part of
the SQL operations package or not.
Access Type Indicates the access type of an operation:
B Browse
S Stable
R Repeatable
Conc Check Indicates the type of concurrency check performed by an
operation:
N None
R Row
Lock Mode Indicates the locking mode of an operation:
S Shared
E Exclusive
Sort Dir Indicates the sort direction of the FETCH operation:
A Ascending
D Descending
Pos Mode Indicates the positioning mode of the FETCH operation:
E Exact
A Approximate
T Table
Start Pos Indicates the starting position of the FETCH operation:
F First
C Current
N Next
For Update Indicates whether rows are retrieved by the FETCH operation.