Export Data from Dataset to a File
This procedure is used to export data from a dataset to a file. The data can then be processed and displayed in Microsoft Excel.
Before you start
- A dataset must be created. See supporting function in Datasets.
- Data must be specified in the dataset. See these documents:
- A report must be defined with references to a transfer file and defined columns in program 'Sales Stats/Budget Report. Open' (OSS412). See Report Processing.
Follow these steps
-
Select program 'Sales Stats/Budget. Print' (OSS417).
-
Specify the report ID, year, period number, and report level. Note that relative periods used for the report column are calculated from this period number and year. A transfer file is created and placed in library QRPLOBJ. If the file was already created from previous runs, the contents will be changed. This file is created for direct transfer to PC or server, and is therefore deleted during the next initial program load (IPL) by the AS/400.
-
Transfer the file to PC or server using a file transfer tool.
-
Retrieve the file in the desired tool for further processing or display.