Customizing Your Environment Using SET Commands

You can issue a SET command by coding it directly in a stored procedure or by using the SET tool. If you use the SET tool, a SET command will be generated, in the stored procedure, for the report you are developing.

The format of a SET command is:

SET parameter=option

You have a choice of different parameters that control different aspects of the product. Each parameter has a set of options, one of which is usually a default setting. You can change the parameters and the options for the parameters.

To change the default character for missing data (NODATA) from a period to the word NONE and to suppress default page numbering (PAGE-NUM), issue the following command:

SET NODATA=NONE, PAGE-NUM=OFF

To see the result, issue the following request:

TABLE FILE EMPLOYEE
PRINT CURR_SAL BY EMP_ID
ACROSS DEPARTMENT
END

Run the request. The output is:

In the output, NONE appears when there is no salary information for a specific employee, because that employee does not work in the department that is referenced. There is no page number at the top of the output.

To see a list of SET commands, issue the following request:

? SET
END

Run the request. The output is:

Note: The parameters may be different depending on your platform and release.

A complete list of SET parameters and their options is available in the Developing Reporting Applications manual.