Pathmaker Reference Manual

Server Constructs
Macro Language Construct Variables
067869 Tandem Computers Incorporated C–13
#SQLIO-Fetch-Sort-Direction
Sort direction for the generated FETCH code, for the current SQLIO section.
Values: ASC, DESC (empty if SQLIO-Generate-Fetch = N)
#SQLIO-Fetch-Start-Position
Start position for the generated FETCH code, for the current SQLIO section.
Values: F, C, N (empty if SQLIO-Generate-Fetch = N)
F = First
C = Current
N = Next
#SQLIO-Generate-Delete
Generate DELETE operation code for the current SQLIO section.
Values: Y, N
#SQLIO-Generate-Fetch
Generate FETCH operation code for the current SQLIO section.
Values: Y, N
#SQLIO-Generate-Insert
Generate INSERT operation code for the current SQLIO section.
Values: Y, N
#SQLIO-Generate-Select
Generate SELECT operation code for the current SQLIO section.
Values: Y, N
#SQLIO-Generate-Update
Generate UPDATE operation code for the current SQLIO section.
Values: Y, N
#SQLIO-Insert-Access-Type
Access type for INSERT operation for the current SQLIO section.
Values: STABLE, REPEATABLE (empty if SQLIO-Generate-Insert = N)
#SQLIO-Macro-Name
Name of the Macro which implements the current SQLIO section.
Values: String, up to 30 characters