Joined: 06 Jun 2008 Posts: 8212 Location: Dubuque, Iowa, USA
but I'm not getting the correct output in the first step:(
Help me.. IF there is any other option to achieve this simpler..?
Okay, you are telling us NOTHING and expect us to help you -- getting impatient if it is not fast enough, too? You need to learn how to ask a question and what patience is. This is a voluntary forum -- people answer when and if they have time to do so; if you need a fast answer you should pay a consultant who can give you fast answers.
When you say you are not getting the correct output, do you mean:
1. you are getting no output at all?
2. the job is abending with some system abend code?
3. the job is abending with some user abend code?
4. you are getting output but it does not include all the records you expected?
5. you are getting output but it includes records you did not expect?
6. you are getting message from Syncsort that indicate a problem?
7. something else enitrely -- which you didn't bother to explain?
The usual request is to use the Code tag to paste some sample data records and the expected output from those sample records -- which allows us to verify you have correctly stated what you want done.