How to: |
The SET command enables you to customize both the application development and runtime environment. It controls the way that reports and graphs display on the screen or printer, the content of reports and graphs, data retrieval characteristics that affect performance, and system responses to end user requests.
SET parameter = option[, parameter = option,...]
where:
Is the setting you wish to change.
Is a valid value for the parameter.
You can set several parameters in one command by separating each with a comma.
You may include as many parameters as you can fit on one line. Repeat the SET keyword for each new line.
The following example sets two parameters in one command in a stored procedure. The first parameter, NODATA, changes the default character for missing data from a period to the word NONE. The second parameter, PAGE-NUM, suppresses default page numbering.
SET NODATA = NONE, PAGE-NUM = OFF TABLE FILE EMPLOYEE PRINT CURR_SAL BY EMP_ID ACROSS DEPARTMENT END
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.
The output is:
DEPARTMENT EMP_ID MIS PRODUCTION ------------------------------------------- 071382660 NONE $11,000.00 112847612 $13,200.00 NONE 117593129 $18,480.00 NONE 119265415 NONE $9,500.00 119329144 NONE $29,700.00 123764317 NONE $26,862.00 126724188 NONE $21,120.00 219984371 $18,480.00 NONE 326179357 $21,780.00 NONE 451123478 NONE $16,100.00 543729165 $9,000.00 NONE 818692173 $27,062.00 NONE
Many SET parameters that change system defaults can be issued from TABLE and GRAPH requests. SET used in this manner is temporary, affecting only the current request. The syntax is
ON {TABLE|GRAPH} SET parameter value [AND parameter value ...] ? SET NOT ONTABLE
where:
Is the setting you wish to change.
Is a valid value for the parameter.
To see a list of parameters that cannot be set within TABLE, issue the following command:
? SET NOT ONTABLE
For details on the SET parameters that you can use to control graphs, see Creating a Graph in the Creating Reports manual.
In the following example, the command ON TABLE SET changes the default character for missing data from a period to the word NONE and suppresses default page numbering.
TABLE FILE EMPLOYEE PRINT CURR_SAL BY EMP_ID ACROSS DEPARTMENT ON TABLE SET NODATA NONE AND PAGE-NUM OFF END
In the output, NONE appears when there is no salary information for a specific employee. There is no page number at the top of the output.
The output is:
DEPARTMENT EMP_ID MIS PRODUCTION ------------------------------------------- 071382660 NONE $11,000.00 112847612 $13,200.00 NONE 117593129 $18,480.00 NONE 119265415 NONE $9,500.00 119329144 NONE $29,700.00 123764317 NONE $26,862.00 126724188 NONE $21,120.00 219984371 $18,480.00 NONE 326179357 $21,780.00 NONE 451123478 NONE $16,100.00 543729165 $9,000.00 NONE 818692173 $27,062.00 NONE
|
Information Builders |