---
title: "QMF: EXPORT Report to Dataset"
description: "The best and simple command flow which helps you to get Report from QMF tool."
url: https://srinimf.com/2010/09/04/qmf-export-report-to-dataset/
date: 2010-09-04
modified: 2026-10-07
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2010/09/qmf-tutorial.jpg?fit=1200%2C900&ssl=1
categories: ["QMF"]
tags: ["How to Export QMF report to a dataset"]
type: post
lang: en
---

# QMF: EXPORT Report to Dataset

[EXPORT REPORT TO](https://srinimf.com/2016/02/02/qmf-export-report-to-excel-or-word-document/) ‘USERID.TEMP.DATA’
You will then need to drop into EDIT, delete the first 12 or so lines of QMF control data, and the last 3 also, and shift the whole dataset 18 characters to the left.

Related[Mainframe tip to cut first 10 lines, last 10 lines from 10000 lines dataset](https://srinimf.com/2015/08/23/mainframe-tip-to-cut-first-10-lines-last-10-lines-from-10000-lines-dataset/)

[![QMF Best tutorial](https://i0.wp.com/imagizer.imageshack.com/img912/3517/v2qEHd.jpg?resize=418%2C107)](http://www.jerseyshorecomputertutors.com/mainframe/manuals/DB2_QMF_using_qmf.pdf)*QMF best tutorial*

Related[QMF: EXPORT Report to Dataset](https://srinimf.com/2010/09/04/qmf-export-report-to-dataset/)

You will then have the data that you saw on your QMF panel in the dataset of your choice.

If the data is too large to edit in the fashion above, then you need [to print](https://srinimf.com/2021/11/20/python-program-to-print-name-in-reverse-order/) it to a dataset. Follow these steps:

- From outside of QMF allocate a dataset large enough in terms of tracks and cylinders and wide enough (LRECL) for your report.
- Go into QMF and generate your report.
- Type ISPF on the QMF command line
- Go to Option 6 (TSO)
- Issue the command FREE DD(DSQPRINT)
- Issue the command ALLOC DD(DSQPRINT) DS(‘userid.dataset.name’) SHR putting in the correct dataset name allocated in)
- Type =X
- From within QMF issue the command PRINT REPORT (PRINTER=*printer* LENGTH=CONT

This will put the output from QMF into your predefined dataset.

**Also Read**

- [QMF Best examples on PRINT](https://www.ibm.com/support/knowledgecenter/en/SS9UMF_10.1.0/guide/USRNPIIpcprint.html)

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2010%2F09%2F04%2Fqmf-export-report-to-dataset%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2010%2F09%2Fqmf-tutorial.jpg%3Ffit%3D1200%252C900%26ssl%3D1&description=QMF%3A%20EXPORT%20Report%20to%20Dataset)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2010/09/04/qmf-export-report-to-dataset/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2010/09/04/qmf-export-report-to-dataset/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2010/09/04/qmf-export-report-to-dataset/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2010/09/04/qmf-export-report-to-dataset/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20QMF%3A%20EXPORT%20Report%20to%20Dataset&body=https%3A%2F%2Fsrinimf.com%2F2010%2F09%2F04%2Fqmf-export-report-to-dataset%2F&share=email)
-

### Like this:

Like Loading…