Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 8593
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us