I have a requirement where I am trying to match two files based on a common key, if they key matches, then I have to take a corresponding field from the matching key from file 2 and update it in file 1.
File1 -
Lrecl of 80, FB.
Field-Name is from character 18 to 38.
File2 -
Lrecl of 80, FB
Name1 is from character 1 to 20
Name2 is from character 30 to 50
If Name2 is present in File1 as Field-name, then replace Name1 in place of Field-name in File1. This has to be done for hundred's of records in File2.
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
Apotheosis,
The job runs fine with DFSORT. The messages indicates you are using SYNCSORT. 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.
Thanks Skolusu, must be having a bad day because fortunately my shop has ICETOOL as well, changed the job to use ICETOOL and it fails with a return code 20, exp 20. Need to have a look at this.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Apotheosis,
Wow. You really are confused!
DFSORT's ICETOOL is only available with DFSORT. Since you have Syncsort, you are actually using SYNCTOOL, not ICETOOL. Full doc for DFSORT's ICETOOL is available on the web. Doc for Syncsort's SYNCTOOL is not available at all.
ICETOOL/SYNCTOOL use different JCL and syntax then DFSORT/Syncsort. You can't just change PGM=SORT to PGM=ICETOOL and expect it to work. You got the RC=20 because you don't have the correct JCL. But those DFSORT statements won't work with Syncsort or SYNCTOOL, even if you get the JCL right, because Syncsort doesn't support some of the keywords that DFSORT supports for JOINKEYS.
I'm moving your Topic to JCL where somebody might (or might not) help you to use Syncsort or SYNCTOOL to do what you want.