On the Advanced Report Writer/Mass Load Selection screen you can enter up to five conditional expressions that select and sort a subset of records from the file used to generate the report or to update by the mass load. Each expression uses a combination of verbs, modifiers, conjunctions, dictionary item names, and operators to select a subset of records from the file. The system applies each additional expression to the records selected by the previous expression.
To enter selection data using the Advanced RW/ML Selection screen:
Log into the character-based system. This feature is not available in a Solar Eclipse interface.
With a report or mass load design displayed on the Report Writer/Mass Load Design screen, use the Adv Selection hot key to display the Advanced Report Writer/Mass Load Selection screen.
To run a report or mass load for a limited number of records, enter that number in the Sample field.
This is useful for testing the design on a sample before processing the entire file and obtaining reports such as Top 100 Products or Top 10 Customers.
In the Reselect (Y/N) field, indicate whether the system should re-select the records each time the report or mass load is run.
Enter up to five conditional statements using TCL retrieve sentence operators.
You can only have one conditional statement per line; start the first statement with WITH.
One statement can contain multiple conditions; connect each additional condition to the previous one with the AND or OR conjunction.
We recommend that you not use ANDs and ORs in the same condition.
You can use parentheses in the statement to change the order in which the statement evaluates.
Use the BY and BY-DESC operators to enter sort criteria.
Note: To clear statements from the screen, use the Delete Selections hot key. The system prompts you to confirm the deletion.
Use the Selection Data hot key to enter default selection data values, as needed.
In some cases, the system requires additional data from you for a dictionary item listed on the Report Writer/Mass Load Selection screen to select the correct record.
Use the Begin Select hot key to select and sort the records.
If the program requires selection data, the Selection Prompts screen displays. The screen lists the prompts for any required selection data for which defaults do not exist. Enter the requested information for each prompt and press Enter.
The Count column displays the number of records selected by each conditional expression.
Press Esc to return to the Report Writer/Mass Load Design screen, where you can run the report or begin the mass load.
See Also: