View previous topic :: View next topic
|
Author |
Message |
ramupinnu
New User
Joined: 10 Apr 2006 Posts: 4 Location: Bangalore
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
What sort of requirement would require multiple datasets consisting of one record each? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
|