Step 2: Populate the subfile with Suprtool

:run SUPRTOOL.PUB.ROBELLE

>base STORE,5,READER
>get D-SALES
>if PRODUCT="WIDGET"
>sort CUST-ACCOUNT
>output SALESUB,erase
>xeq

IN=20, OUT=6. CPU-Sec=1. Wall-Sec=1.

Previous slide Next slide Back to the first slide Back to the main menu View Graphic Version

Notes:


Once you have created a PowerHouse subfile with the correct structure, you can use Suprtool to select records from the datasets, sort them, and then write them to the subfile.

By default, the Output command creates a new file. You can overwrite the contents of an existing subfile by using the Erase option, which overwrites the data records without affecting the mini-dictionary in the file labels. If you want to add records to the end of a subfile without overwriting the existing records, use the Append option.