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: 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 Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm

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