Defining and Editing Programs

A program, like a dimension or a variable, is a workspace object. You define a program using the DEFINE command. The following example defines a program named hello.

DEFINE hello PROGRAM

Once you have defined a program object, you need to add the body of the program to it.

OLAP Worksheet provides an editor that you can use to add content to the program definition.

Formatting Guidelines for Editing Programs

Use the following formatting guidelines as you add lines to your program:

• Each line of code can have a maximum of 4000 bytes.
• To continue a single command on the next line, place a hyphen (-) at the end of the line to be broken. The hyphen is called a continuation character.

  You cannot use a continuation character in the middle of a text literal.

• To write more than one command on a single line, separate the commands with semicolon (;).
• Enclose literal text in single quotation marks ('). To include a single quotation mark within literal text, precede it with a backslash (\).
• Precede comments with double quotation marks ("). You can place a comment, preceded by double quotation marks, either at the beginning of a line or at the end of a line, after some commands.

The following program named hello displays the phrase "Hello World."

DEFINE hello PROGRAM
PROGRAM
SHOW 'Hello World'
END