The export command in QMF. You can use it to export your SQL query to a data set where you can use it for future use.
EXPORT :
- Sends Queries, forms, procedures, reports, charts, and data from temporary storage to a TSO data set
- Queries, forms, procedures, and tables from the database to a TSO data set
Syntax:
Export Report/Query/Form to data set Name
Once you got data into a data set. Then go for FTP either batch or on-line. You can download the report either into word or Excel document as you wish.
Related: