Pathmaker Reference Manual

Server Constructs
Macro Language Construct Variables
C–12 067869 Tandem Computers Incorporated
#SQLIO-Access-Path-Is-Unique
The access path for the current SQLIO section has the "unique" attribute set. ("N" if no
access path exists.).
Values: Y, N
#SQLIO-AP-Extension-Is-Valid
The access path for the current SQLIO section has a valid extension, according to the
criteria established to generate code for the FETCH operation. ("N" if no access path
exists.) (A valid extension may be empty.).
Values: Y, N
#SQLIO-Delete-Access-Type
Access type for DELETE operation for the current SQLIO section.
Values: STABLE, REPEATABLE (empty if SQLIO-Generate-Delete = N)
#SQLIO-Delete-Concurrency-Ck
Generated DELETE code does concurrency checking, for the current SQLIO section.
Values: N (for No), R (for Row)
#SQLIO-Fetch-Access-Type
Access type for FETCH operation for the current SQLIO section.
Values: BROWSE, STABLE, REPEATABLE (empty if SQLIO-Generate-Fetch = N)
#SQLIO-Fetch-For-Modification
Generate FETCH code for UPDATE/DELETE operations for the current SQLIO
section.
Values: Y, N
#SQLIO-Fetch-Lock-Mode
Locking mode for the generated FETCH code, for the current SQLIO section.
Values: SHARE, EXCLUSIVE (empty if SQLIO-Generate-Select = N)
#SQLIO-Fetch-Position-Mode
Positioning mode for the generated FETCH code, for the current SQLIO section.
Values: E, A, T (empty if SQLIO-Generate-Fetch = N)
E = Exact
A = Approximate
T = Table