Control statement overview
Statement | Description |
|---|---|
GLOBAL | |
LOAD | Load input data in a temporary file to a table Specify one per output table. In the DPRSMF job, this statement is used to load processed SMF input data from a temporary file to a detail output table, or after a SUMMARIZE statement to load summarized SMF input data from a work file to an output summary table. In the DPRSUM job, this statement is used after a SUMMARIZE statement to load summarized data from a work file to an output summary table. For more information, see LOAD. |
SUMMARIZE | Summarize input data to a work file This statement must be followed by a LOAD statement. Specify one per summary output table (valid only for accounting tables). In the DPRSMF job, this statement is used to summarize SMF input data. In the DPRSUM job, this statement is used to summarize data in a table. The input table may be either a detail table or a summary table that is to be even further summarized. For more information, see SUMMARIZE. |
PURGE | Purge data that is older than the specified datetime from a table Specify one statement per table where purging is required. In the DPRSMF job, this statement is used to purge table data daily; for example, deleting the data of the oldest day in the table while loading the data from the previous work day. In the DPRSUM job, this statement is used to purge table data less frequently, during a summarization job cycle that may be run only weekly or monthly. For more information, see PURGE. |
UNLOAD | Unload data from a table to a data set This statement can be used for table migration; for example, to unload data from a table where all possible columns are defined to a smaller table with only a subset of columns. For more information, see UNLOAD. |