View previous topic :: View next topic |
Author |
Message |
seekaysk Beginner
Joined: 31 Aug 2007 Posts: 49 Topics: 15
|
Posted: Thu Sep 27, 2007 12:53 pm Post subject: Create as many output files as different Account numbers |
|
|
Hi,
I have some unique requirement.
My Input file (FB) is somewhat like this:
Code: | some1 records.............
1234 ...................
some2 records.............
*************************
some3 records.............
2345 ...................
some4 records.............
*************************
some5 records.............
1234 ...................
some6 records.............
*************************
some7 records.............
4567 ...................
some8 records.............
************************* |
The marker "some records" are not constants. I mean, they may be 1 record or 2 records or more.
The only thing fixed is : the Account numbers (e.g. 1234, 2345, etc..) location and the record breakers "*************".
The requirement is to create different output files for different account numbers.
the output should be like:
output 1:
Code: | some1 records.............
1234 ...................
some2 records.............
*************************
some5 records.............
1234 ...................
some6 records.............
************************* |
output 2:
Code: | some3 records.............
2345 ...................
some4 records.............
************************* |
output 3:
Code: | some7 records.............
4567 ...................
some8 records.............
************************* |
Can anybody help me with this.
Thanks. |
|
Back to top |
|
 |
CICS Guy Intermediate
Joined: 30 Apr 2007 Posts: 292 Topics: 3
|
Posted: Thu Sep 27, 2007 1:47 pm Post subject: |
|
|
How many different "Account numbers" can you have? |
|
Back to top |
|
 |
seekaysk Beginner
Joined: 31 Aug 2007 Posts: 49 Topics: 15
|
Posted: Thu Sep 27, 2007 2:02 pm Post subject: |
|
|
It can be many. Even I don't know. Depends on how the input file comes to me. Is this really necessary ? _________________ Thanks. |
|
Back to top |
|
 |
CraigG Intermediate
Joined: 02 May 2007 Posts: 202 Topics: 0 Location: Viginia, USA
|
Posted: Thu Sep 27, 2007 2:27 pm Post subject: |
|
|
seekaysk wrote: | It can be many. Even I don't know. Depends on how the input file comes to me. Is this really necessary ? |
If you receive a file with 5000 account numbers you will create 5000 files. Is this really necessary? |
|
Back to top |
|
 |
seekaysk Beginner
Joined: 31 Aug 2007 Posts: 49 Topics: 15
|
Posted: Thu Sep 27, 2007 2:32 pm Post subject: |
|
|
CraigG, thanks.
1. Actually I need to send these files via emails. so I need them as different output files.
2. I can say the different no. of Account numbers will be max. 50. But then does it really need hard-coding of 50 output files ?
Thanks. _________________ Thanks. |
|
Back to top |
|
 |
CICS Guy Intermediate
Joined: 30 Apr 2007 Posts: 292 Topics: 3
|
Posted: Thu Sep 27, 2007 5:45 pm Post subject: |
|
|
seekaysk wrote: | Actually I need to send these files via emails. so I need them as different output files. | Thanks....Now you have to look at the problem from a different direction....
Instead of seperate files, why not wrap the data with the email stuff and create one output that is then emailed (SPAM? )..... |
|
Back to top |
|
 |
hchinnam Beginner
Joined: 04 Feb 2005 Posts: 31 Topics: 10
|
Posted: Fri Sep 28, 2007 5:23 am Post subject: |
|
|
Why don't you go for a program. |
|
Back to top |
|
 |
vkphani Intermediate

Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Fri Sep 28, 2007 5:33 am Post subject: |
|
|
Do you have * as delimiter? |
|
Back to top |
|
 |
|
|