Pathmaker Reference Manual

SERVICE Statement
Pathmaker Application Definition Language (PMADL)
2–48 067869 Tandem Computers Incorporated
sql-operation-clause is:
SQL-OPERATIONS name
( [ ACCESS-PATH name ]
[ , MACRO name ]
[ , INSERT [ ( { GENERATE {YES | NO } } , ...)]
{ ACCESS-TYPE {STABLE } }
{ {REPEATABLE } }
[ , DELETE [ ( { GENERATE {YES | NO } } , ...)]
{ ACCESS-TYPE {STABLE } }
{ {REPEATABLE } }
{ CONCURRENCY-CHECK {ROW } }
{ {NONE } }
[ , UPDATE [ ( { GENERATE {YES | NO } } , ...)]
{ ACCESS-TYPE {STABLE } }
{ {REPEATABLE } }
{ CONCURRENCY-CHECK {ROW } }
{ {NONE } }
[ , SELECT [ ( { GENERATE {YES | NO } } , ...)]
{ ACCESS-TYPE {BROWSE } }
{ {STABLE } }
{ {REPEATABLE } }
{ LOCK-MODE {SHARED } }
{ {EXCLUSIVE } }
[ , FETCH [ ( { GENERATE {YES | NO } } , ...)]
{ ACCESS-TYPE {BROWSE } }
{ {STABLE } }
{ {REPEATABLE } }
{ LOCK-MODE {SHARED } }
{ {EXCLUSIVE } }
{ SORT {ASCENDING } }
{ {DESCENDING } }
{ POSITION-MODE }
{ {EXACT } }
{ {APPROXIMATE} }
{ {COMPLETE } }
{ START {FIRST } }
{ {CURRENT } }
{ {NEXT } }
{ FOR-UPDATE {YES } }
{ {NO } }