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

Follow these steps

  1. Select program 'Sales Stats/Budget. Print' (OSS417).

  2. 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.

  3. Transfer the file to PC or server using a file transfer tool.

  4. Retrieve the file in the desired tool for further processing or display.

Related topics