Groups DEC DATATRIEVE statements into a single compound statement called a BEGIN-END block. Format BEGIN statement-1 [statement-2] . . . END
1 – Arguments
BEGIN Marks the beginning of a BEGIN-END block. statement Is a DEC DATATRIEVE statement. Within the BEGIN-END block, end each statement with a semicolon, a RETURN, or both. END Marks the end of the BEGIN-END block.
2 – Examples
The following example shows how to store five records in the domain PHONES, each having LOCATION MB1-H2 and DEPARTMENT CE. The SET NO PROMPT command suppresses the "[Looking for . . .]" prompts preceding each CON> prompt. This example also shows how DEC DATATRIEVE responds to CTRL/C and CTRL/Z when it is prompting you for input. DTR> READY PHONES WRITE DTR> SET NO PROMPT DTR> REPEAT 5 STORE PHONES USING DTR> BEGIN CON> NAME= *.NAME CON> NUMBER= *.NUMBER CON> LOCATION= "MB1-H2" CON> DEPARTMENT= "CE" CON> END Enter NAME: FRED Enter NUMBER: 555-1234 Enter NAME: GERRY Enter NUMBER: <CTRL/C> ^C Enter NUMBER: <CTRL/Z> Execution terminated by operator DTR> The following example shows how to use a BEGIN-END block to put three statements in the USING clause of a MODIFY statement, print a YACHTS record, modify the price, and print the result of the modification: DTR> READY YACHTS WRITE DTR> SET NO PROMPT DTR> FOR YACHTS WITH PRICE = 0 CON> MODIFY USING CON> BEGIN CON> PRINT CON> PRICE = *."NEW PRICE" CON> PRINT CON> END LENGTH OVER MANUFACTURER MODEL RIG ALL WEIGHT BEAM PRICE BLOCK I. 40 SLOOP 39 18,500 12 Enter NEW PRICE: 30000 LENGTH OVER MANUFACTURER MODEL RIG ALL WEIGHT BEAM PRICE BLOCK I. 40 SLOOP 39 18,500 12 $30,000 BUCCANEER 270 SLOOP 27 5,000 08 Enter NEW PRICE: <CTRL/Z> Execution terminated by operator DTR> The following example shows how a BEGIN-END block is treated as a single statement: DTR> DEFINE PROCEDURE LOOP_EXAMPLE DFN> PRINT "SHOW HOW A BEGIN-END WORKS WITH REPEAT" DFN> PRINT "AND MORE THAN ONE STATEMENT" DFN> END_PROCEDURE DTR> DTR> REPEAT 2 :LOOP_EXAMPLE SHOW HOW A BEGIN-END WORKS WITH REPEAT SHOW HOW A BEGIN-END WORKS WITH REPEAT AND MORE THAN ONE STATEMENT DTR> REPEAT 2 BEGIN :LOOP_EXAMPLE; END SHOW HOW A BEGIN-END WORKS WITH REPEAT AND MORE THAN ONE STATEMENT SHOW HOW A BEGIN-END WORKS WITH REPEAT AND MORE THAN ONE STATEMENT DTR>