View previous topic :: View next topic
|
Author |
Message |
shell100
New User
Joined: 14 Apr 2006 Posts: 25 Location: Banglore,India
|
|
|
|
Hi,
I have a requirement to allocate output file based upon the different of record type in input file. The no of Record type are not fixed & could be N.
For ex -
HDR1ASAS122222
DTL1SASA1312321
TRL1ASAS1121311
HDR2SADSAD1221
DTL2DSD13123211
TRL2SDSAD11213
HDR3FDSFSD1122
DTL3DSFSF213111
TRL3DFSFS211213
I need all of these records in 3 different files.
1st file for HDR1, DTL1, TRL1
2nd File for HDR2, DTL2,TRL2.....so on
Can any one suggest some approach for this? |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
Hi,
Use the OUTFILL for creating 3 files and use the IF THEN WHEN condition to differentiate the 3 record like =(4,1,EQ,CH,’1’)
BUILD
Check for the syntax, I hope this will help |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
How do you differentiate between headers, trailers and data records.
What positions are the keys, what length and what format.
What are the file attribute for the input file, RECFM & LRECL |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
The no of Record type are not fixed & could be N. |
What is the maximum? |
|
Back to top |
|
|
|