------------------------------------------------------------------------------- ?ASSIGN [TO] ?ASSIGN } [[, ] ?ASSIGN , create-open-spec,create-open-spec,... ?ATTACH [process-name] ?COMPILE [( , ... )] TO ?DICTIONARY [] DICTIONARY [] [;] ?EDIT [] ?EXECUTE ?HELP [] ?OUT [] ?RUN [( , ... )] ?SECTION ?SOURCE [( , ... )] set @BLANK-WHEN-ZERO ON | OFF set @BREAK-KEY ON | OFF set @CENTER-PAGE ON | OFF set @COPIES set @COST-TOLERANCE set @DATE-FORMAT set @DECIMAL "char" set @DISPLAY-COUNT set @HEADING ON | OFF set @LINES set @MARGIN set @NEWLINE "char" set @NONPRINT-REPLACE "char" set @OVERFLOW "char" set @PAGES set @PRIMARY-EXTENT-SIZE set @READS set @SECONDARY-EXTENT-SIZE set @SPACE set @STATS ON | OFF set @SUBTOTAL-LABEL set @SUMMARY-ONLY ON | OFF set @TARGET-RECORDS set @TIME-FORMAT set @UNDERLINE "char" set @VSPACE set @WARN ON | OFF set @WIDTH DECLARE { DECLARE { "[" "]" DECLARE { ( ) DECLARE { = ( [, [] , []] ) [INTERNAL ] } [AS ] } , ... [;] [HEADING ] } TITLE [CENTER] [;] SUBTITLE [CENTER] [;] SUBFOOTING [CENTER] [;] FOOTING [CENTER] [;] OPEN , ... [;] OPEN [AS] COPY [OF] , ... [;] LINK TO [OPTIONAL] {VIA }, ... [;] LINK TO [OPTIONAL] , ... [;] ?SHOW OPEN ?SHOW LINK ?SHOW CONTROL ?SHOW LIMITS ?SHOW ASSIGN [] ?SHOW ?SHOW ?SHOW LIST [UNIQUE] LIST [BY] [ , ...] [BY] DESC { } {ASCD } {DESC } { := } [ , ...]} , ... [WHERE [(] AND|OR [)] ... [WHERE BEGINS WITH [WHERE CONTAINS [WHERE [NOT] EQ|EQUAL|IS|NE|GE|GT|LE|LT|<|>|<>|=|>=|<=|LESS [THAN]|GREATER [THAN] || [WHERE = THRU } [NOHEAD ALL ] [NOPRINT ALL] [CENTER ALL ] [SUPPRESS [WHERE] ] [ , ...] {BEFORE CHANGE [ON] PRINT [CENTER]} {AFTER CHANGE [ON] PRINT [CENTER]} AT END PRINT [CENTER] [;] AT START PRINT [CENTER] [;] AT END PRINT [CENTER] [;] AT START PRINT [CENTER] [;] [;] DELINK TO [OPTIONAL] [;] DELINK VIA [;] DELINK TO [OPTIONAL] [;] DELINK , ... [;] CLOSE ,,,,[;] EXIT [;] ------------------------------------------------------------------------------- AVG|COUNT|MAX|{MIN|SUM| {} ({ }[OVER ALL ][WHERE ]) ({}[OVER ][WHERE ]) (UNIQUE [OVER ALL] [WHERE ] ) ------------------------------------------------------------------------------- Examples: ------------------------------------------------------------------------------- OPEN order,odetail,parts; LINK order to odetail VIA ordernum; LINK odetail to parts VIA partnum; LIST BY salesman, SUM (price * quantity) OVER salesman); LIST AVG (salary), grossavg (salary); LIST BY by-item-1, BY by-item-2, target-item-1 AVG(target-item-1 OVER by-item-2); OPEN employee; LIST regnum, branchnum, WHERE salary GT AVG( salary OVER regnum ); DECLARE fixit INTERNAL F6.2; LIST fixit := AVG (price OVER partnum); ------------------------------------------------------------------------------- FIND [UNIQUE] {{BY } } {{BY DESC } } ( {[ :=] { } } , ... ) {{ASCD } } {{DESC } } WHERE ; ------------------------------------------------------------------------------- PARAM { [INTERNAL ]} , ... [;] SET TO SET SET "[" "]" SET SET