QMF Export Report to Excel or Word document

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:

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.