Kitz wrote:I can say this worked partially, but for some test cases it did not worked. I trying to figure out what could be the problem. I will provide that test data by today evening which probably, you can better say what is going wrong.
The job I posted should have worked in all scenarios . Show me the error data and explain why you think it is an error.
Kitz wrote:Additionally, I was also trying to work out a simple solution for this. In my trial, I was just working out with your first solution. Strangely, our scheduler is not recognising the '?' in REFORMAT FIELDS=(F1:1,40,?). Please advise is there any other alternative for this?
I would love to see the simpler solution. Most JCL checker software are way beyond keeping up with the latest features of DFSORT and you should ignore those errors if you are running DFSORT and your shop have the latest PTF's installed which supports the ? on Joinkeys. If you are running Syncsort, then you need to find someone else to help you as I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
Run the following Job and post the complete sysout , so that we can determine the level of DFSORT you running
//SYSOUT DD SYSOUT=*
//SORTIN DD *
//SORTOUT DD DUMMY
//SYSIN DD *