|
View previous topic :: View next topic
|
| Author |
Message |
ch.sridhar
New User
Joined: 01 May 2006
Posts: 7
Location: INDIA, Mumbai
|
|
|
|
I am taking an input file and sorting it based on some conditions. But the first record in the output file of the sort should have some extra characters which should not come from the next records in the output file.
So is there any way that this task can be accomplished in a single or multiple SYNCSORT steps?
Thanks&Regards,
Sridhar |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| So is there any way that this task can be accomplished in a single or multiple SYNCSORT steps? |
I believe you'll be able to do what you want using a HEADER.
You can find the complete info jn the Syncsort manual (available for free for Syncsort to licensed users) and you might search in our forums - make sure any solution you find will work with Syncsort. |
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
ch.sridhar
Explain your scenario with proper set of i/p and o/p records, so as to help you! |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
sridhar,
| Quote: |
| So is there any way that this task can be accomplished in a single or multiple SYNCSORT steps? |
Yes, this is possible using SYNCSORT. First sort the input records based on the conditions and then add the SEQNUM on the sorted output. Then add the extra characters for the record with seqnum 1 and then build excluding the SEQNUM numbers.
Post the sample input/output incase if you need a working JCL. |
|
| Back to top |
|
|
|
|
