Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
need generate the separate file report

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
ramupinnu

New User


Joined: 10 Apr 2006
Posts: 4
Location: Bangalore

PostPosted: Wed Aug 08, 2007 4:10 pm    Post subject: need generate the separate file report
Reply with quote

Hi,
We need to generate a report using input file.

Every Day we are getting the INPUT file from the client, the file contain the customer details. And The number of records are varying in INPUT while receiving, i.e suppose today we received 5 customer information and tomorrow may be 6 or 7 or ……..etc. it depends

For each Customer we need generate the separate file report

Can please guide how to go about this?

Regards,
Ram

EX1:
Code:
 
        INPUT file
           0011RAM10000
           0020NAG32000
     Out file 1
          No : 0011
          Name : RAM
          Sal    : 10000
     Out file 2
          No : 0020
          Name : NAG
          Sal    : 32000


EX2:
Code:

        INPUT file
           0009ABC22222
           0011RAM10000
           0020NAG32000
      Out file 1
          No : 0009
          Name : ABC
          Sal    : 22222     
     Out file 2
          No : 0011
          Name : RAM
          Sal    : 10000
     Out file 3
          No : 0020
          Name : NAG
          Sal    : 32000


EX3:
Code:

        INPUT file
           0009ABC22222
           0011RAM10000
           0019XYZ33333
           0020NAG32000
      Out file 1
          No : 0009
          Name : ABC
          Sal    : 22222     
     Out file 2
          No : 0011
          Name : RAM
          Sal    : 10000
     Out file 3
          No : 0019
          Name : XYZ
          Sal    : 33333
     Out file 4
          No : 0020
          Name : NAG
          Sal    : 32000
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Aug 08, 2007 4:24 pm    Post subject:
Reply with quote

What sort of requirement would require multiple datasets consisting of one record each?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Wed Aug 08, 2007 4:49 pm    Post subject:
Reply with quote

William Thompson wrote:
What sort of requirement would require multiple datasets consisting of one record each?


Errrrrrrrrr, HOMEWORK ???

But being in a reasonably good mood today icon_evil.gif

You can do it with REXX and create the sysouts independantly, even route the individual sysouts to different places if you want to.

You could probably do it with any programming language.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Wed Aug 08, 2007 7:56 pm    Post subject:
Reply with quote

Ram,

You could dynamically generate a DFSORT job with the needed output DD statements and OUTFIL statements and submit it to the internal reader.

Do you want the output to to go SYSOUT or a data set? If a data set, what would the DD statement for one of the output data sets look like?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm
No new posts unable to set RC = 4 when empty file migusd SYNCSORT 1 Tue Nov 21, 2017 1:21 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us