Pathmaker Reference Manual

Server Constructs
Macro Language Construct Variables
C–14 067869 Tandem Computers Incorporated
#SQLIO-Section-Name S
Section Name for the current SQLIO section.
Values: String, up to 30 characters
#SQLIO-Section-Name-LCU
Name of the current SQLIO Section (lowercase, underscore). .
Values: String, up to 30 characters
#SQLIO-Section-Name-UCU
Name of the current SQLIO Section (uppercase, underscore). .
Values: String, up to 30 characters
#SQLIO-Select-Access-Type
Access type for SELECT operation for the current SQLIO section.
Values: BROWSE, STABLE, REPEATABLE (empty if SQLIO-Generate-Select = N)
#SQLIO-Select-Lock-Mode
Locking mode for the generated SELECT code, for the current SQLIO section.
Values: SHARE, EXCLUSIVE (empty if SQLIO-Generate-Select = N)
#SQLIO-Update-Access-Type
Access type for UPDATE operation for the current SQLIO section.
Values: STABLE, REPEATABLE (empty if SQLIO-Generate-Update = N)
#SQLIO-Update-Concurrency-Ck
Generated UPDATE code does concurrency checking, for the current SQLIO section.
Values: N (for No), R (for Row)
#Version-Nbr Pathmaker version number.
Values: String
Server ITERATE Constructs Following is the syntax for ITERATE constructs used in the context of a server.
The context required by each type of server construct yields a hierarchical relationship
as shown in Figure C-1. These constraints apply to the hierarchy:
#Params, #Server-File, and #Service-File constructs are mutually exclusive. None
of these constructs can be used within the scope of iteration of any other of them.
#File-Data-Columns, #File-Primary-Key-Columns, #SQLIO-Access-Path-Columns,
and #SQLIO-Access_Path-Ext-Columns are likewise mutually exclusive.