Executing OLAP DML and SQL Statements

  1. Within the Command Input window, specify the type of statements you want to execute:

    • To execute OLAP DML statements, deselect SQL mode in the Options menu.

    • To execute SQL statements, select Options > SQL mode.

  2. Specify when you want the statements to execute:

    • If you want the statements to execute as you type them in, select Option > Execute on Enter.

    • If you want the statements to execute only when you select Worksheet > Execute, deselect Execute on Enter.

  3. In the Query (bottom) pane of the Command Input window, type in the statements.

    You can type one statement per line or several statements. To continue statements to the next line, type a continuation character (-) at the end of the current line.

    When SQL mode is selected in the Options menu, separate multiple SQL statements with a new line; do not separate them with a semicolon (;).

  4. When Execute on Enter is deselected, select Execute to execute the statements.