IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to select some part of a report?


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
anilanju

New User


Joined: 24 Jan 2008
Posts: 4
Location: Delhi

PostPosted: Mon Nov 10, 2008 9:21 pm
Reply with quote

Hello all

I am a new member, and i am facing a problem.

I have a report which has ouput deatils of many programs, i need to pick
the data of some programs and copy it to some other PS file.

The format of the report is:
Heading and then the data.

So when i try to use sorting, it just gives me the heading.
What needs to be done so that i get the data also along with the report.

The data contains comments n all, no fixed format.

Or please tell me how to pick few lines from a report without knwoing the exact number of lines...

Thanks
Anubhuti
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Nov 10, 2008 10:49 pm
Reply with quote

Hello,

With what you have posted, no one can help.

You need to post some sample "input", "output", and the processing rules that select/format the output from the sample input.

You should also post the jcl and control statements you have set up so far.

Quote:
Or please tell me how to pick few lines from a report without knwoing the exact number of lines...
There is not now and probably never will be a "do what i want" statement. . .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Nov 10, 2008 11:06 pm
Reply with quote

Based on the information you sent me offline, here's a DFSORT job that will do what you asked for. I assumed your input file and output files have RECFM=FB and LRECL=80, but you can change the job appropriately for other attributes. The job uses DFSORT's new WHEN=GROUP function available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008).

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
1PROGRAM ID : TPMN300  FSADMFIST1                       ABC
  REPORT  ID : TPMN300.02                                 X
                                                  NJR COSTI
0 APPLICATION : NJR     SOURCE : AB     DATA TYPE : HOURS
0                              -----------INPUT------------
  CORP ID  FIST1               RECORDS                AMOUN
.
.
.
1PROGRAM ID : TPMN500  FSADMFIST1                       ABC
  REPORT  ID : TPMN300.02                                 X
                                                  NJR COSTI
0 APPLICATION : NJR     SOURCE : AB     DATA TYPE : HOURS
0                              -----------INPUT------------
 CORP ID  FIST1               RECORDS
.
.
.
0PROGRAM ID : TPMN400  FSADMFIST1
  REPORT ID : TPMN400.01
                               COMMON SUSPENSE
0 APPLICATION : NJR      SOURCE : AB     DATA TYP
0                                -----------INPUT
 CORP ID  FIST1                  RECORDS
-JOURNAL - NJ660X1131
 ACTUALS  DEBITS                  47,427
          CREDITS                 47,427
.
.
.
/*
//SORTOUT DD SYSOUT=*
//SYSIN    DD    *
  OPTION COPY
  INREC IFTHEN=(WHEN=GROUP,BEGIN=(2,12,CH,EQ,C'PROGRAM ID : '),
     PUSH=(81:15,7))
  OUTFIL INCLUDE=(81,7,SS,EQ,C'TPMN300,TPMN400'),
    BUILD=(1,80)
/*


The data for TPMN300 and TPMN400 will be selected for output.

If you don't have z/OS DFSORT PTF UK90013, ask your System Programmer to install it (it's free).

For complete details on the new functions available with PTF UK90013, see:

Use [URL] BBCode for External Links
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts SELECT from data change table DB2 5
No new posts Select two different counts from SQL... DB2 6
Search our Forums:

Back to Top