Friday, March 14, 2014

Report Generation from DB2 Table on Z/Os using QMF EXPORT command

Many times we need to run queries in QMF. The steps below states how to generate report from QMF using EXPORT command.
Step1. Logon to QMF and run the query . Suppose we take a sample query like below
SELECT EMPNO,FNAME,LNAME
FROM EMPLOYEE                        
WHERE SALARY >= 10000
Once we run the query we will get the output in QMF.

EMPNO FNAME  LNAME
----------  ----------  ------------
0001      RYAN      ORLANDO
0002      MIKE      DUTCHER
0003      EN           BOSHER  


Step2.   Down below give the command  'EXPORT REPORT’  as shown below in the command line
EXPORT REPORT TO 'R0XXX.JCL.REPORT ' and press ENTER.
where R0XXX.JCL.REPORT is the dataset we want the QMF data to be put in.
Once done, we will get once notification indicating that the export was successful.
OK, REPORT was  exported to 'R0XXX.JCL.REPORT' . 

Step 3.   Report would contain some extra fields. We need to delete them





Then use the block command   ((16  and ((   to bring format the left alignment and you r done with ur report in ur dataset.

2 comments:

  1. Hi there everyone, it's my first pay a visit at this website, and article is
    really fruitful designed for me, keep up posting these types of articles or
    reviews.

    my website: Organizowanie wesel koło Warszawy

    ReplyDelete
  2. CIITN is the Best Php training institute in Noida and delhi Ncr. You will get Live Project Training on PHP by our PHP expert who have 5+ year industrial experience.Focus on practical and live project training. In our PHP training, we you will learn core PHP, advance PHP, HTML, CSS, JavaScript, jQuery, Bootstrap, Cake PHP and Wordpress.CIITN provides 100% job assistance in PHP training. CIITN is well known PHP coaching center because our 100% PHP students are placed now.


    Ciitnoida provides Core and java training institute in noida. We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-oriented, class-based build of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an all-time high not just in India but foreign countries too.

    By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13 years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best Java training in Noida.


    php training in noida
    java training institute in noida
    javascript training in noida
    linux training in noida
    linux institute in noida
    red hat linux training in noida

    ReplyDelete