Joined: 16 Mar 2008 Posts: 90 Location: tamil nadu
Hi ,
Can anyone help me with this. i need to remove the duplicates in my file based on the fields from (1 to 33 and 44 to 52) . I ran the below jcl but it was not successful.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Well, for one thing, your syntax is wrong. It should be:
Code:
SELECT FROM(SORTIN) TO(SORTOUT)-
ON(1,33,CH) ON(44,9,CH) FIRST DISCARD(SORTXSUM)
Note that you need a separate ON field for each key, and positions 44 to 52 have a length of 9, not 8.
If that doesn't give you what you want, then give more details of what you're trying to do including an example of the records in your input file and what you expect for output and the RECFM and LRECL of the input file.