Requirement from above file is to
1) include records that start with 02 only
2) if there are duplicate record that starts with 02 then keep the single
(can be either first or last) record only.
I am using below control card (CTL1) for the above requiremnt but not getting result
P
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
You've only shown/explained part of your requirement.
Please show an example of the records in each input file and what you expect for output. Explain the complete rules for comparing the two files. Give the RECFM and LRECL of each input file. Give the starting position, length and format of each relevant field in each input file.
I have to compare File1 and File2 on the basis of policy number,
If the policy number present in File2 is not matched with policy number in File1(for records that start with 02)
then policy number from file2 , needs to written to a third file.
If the file2 contains duplicate policy numbers that are not matching with file1 policy number,
then only one instance of policy number from file2 is to be written in third file,
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
Why do you NOT check which sort product you are using before posting, or at least state which one it is
This is yet another case of people not doing their work before asking others to do it for them.
Your product is SYNCSORT NOT DFSORT
So someone has wasted time and effort on a solution that DOES NOT work because you could not be bothered to check which product is in use at your site.