Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Ram,
If you need more specific help on this:
Please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.
Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
i guess i dont have latest sort version i our shop.
You're quite a bit behind in your level of DFSORT. Ask your System Programmer to install z/OS DFSORT PTF UK90025 (Oct, 2010). That will get you up-to-date.
Quote:
is it possible to do using splice in icetool.
I don't know since you still haven't explained clearly what you're trying to do.
Again:
Please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Since you don't have the JOINKEYS PTF, you can use a DFSORT/ICETOOL job like the following instead (I'm assuming you don't have duplicates within file1 or within file2 since you didn't show them in your example):
