Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
If a topic is posted in the wrong part of the forum and it is relocated (as this one has been), the topic will be "gone" if the poster looks in the original part of the forum.
If the maximum number of records produced from a single input record is 3, then here is a SyncSort for z/OS job that will produce the requested output:
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
You really need to express your question / comment in a way which can be easily understood. Give examples if required. Show clearly what it is that you want to have answered.
Joined: 22 May 2009 Posts: 160 Location: Bangalore
The below file with the input as
Trigger-col program
100 AA,AB
200 AC
300 AC,AB,AA
now the program column can have two programs or three or any number base on this the program whcih is a 2 byte field we have to segregate the trigger-col.
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
OK, so what happened when you tried the new input file you have shown with the solution given to you by Alissa.
What effort have YOU made to amend the sort job to cater for more possibilities, and what problems did you encounter. I'm not a great user of either sort product, but the solution does not seem overly difficult, even for me.
Please remember that this is a HELP forum rather than a DO IT FOR ME forum. People help on these forum do so because they want to, and I am sure that they would like to see a lot more effort from posters in trying to resolve their problems before posting.
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
tecnokrat wrote:
now the program column can have two programs or three or any number base on this the program whcih is a 2 byte field we have to segregate the trigger-col.
Yet none of your examples show more than three.
Does "any number base" mean there might be more?
If so, add more"IFTHEN=(WHEN=(" statements until you have accounted for the maximun expected terms.