DO ... DOEND

The DO and DOEND commands bracket a group of one or more statements in a program. DO and DOEND are normally used to bracket one of the following:

A group of statements that are to be executed under a condition specified by an IF command
A group of statements in a repeating loop introduced by FOR or WHILE
The CASE labels for a SWITCH command.

DO and DOEND are like opening and closing parentheses; you cannot use one without the other. You can use DO and DOEND only within programs.

Syntax

statement1

...

statementN

DOEND

Arguments

statement: One or more OLAP DML statements, user-defined programs, or both.

Notes

Nesting

You can put one DO statement inside another to nest groups of statements. You can nest as many groups as you want, if each DO statement has a corresponding DOEND to indicate the end of its statement group.

TEMPSTAT Command and DOEND Command

Within a FOR loop of a program, when a DO/DOEND phrase follows TEMPSTAT, status is restored when the DOEND, BREAK, or GOTO is encountered.

Examples

Example 11-14 DO and DOEND with the FOR Command

Suppose you want to use the ROW command to produce a report that shows the unit sales of tents for each of 2 months. Use DO ... DOEND and DOEND to bracket the ROW and BITAND commands you want to execute repeatedly for each value of the month dimension. You might write the following program.

LIMIT month TO 'Jan96' to 'Feb96'
ROW district
ROW UNDER '-' VALONLY name.product
FOR month
    DO
      ROW INDENT 5 month WIDTH 6 UNITS
      BLANK
    DOEND

The program produces the following output.

BOSTON
3-Person Tents
--------------
     Jan96              307
     Feb96              209