MVSFORUMS.com

[harikiran2001]

I have a file which has rows some thing like this below
x
x
x
y
y
y
a
a
a
i
i
i
I have sort card to remove i,y from the above file some thing like this.
SORT FIELDS=(1,1,CH,A)
OMIT COND=(1,1,EQ,C'i,y')
END
Here is my questions if this omit list is big( i,y) , i would not like to put this whole list in the sort card.Rather i would like to put the list it in another file.
Could this be done like this. Please let me know your suggestions.

[kolusu]

harikiran2001,

Yes you can put unwanted record list in another file and use that file to eliminate the records from the master file.

Inorder to help you we need the LRECL,RECFM of the master file and your lookup file. Also the position and format of the field which needs to be eliminated
_________________
Kolusu
www.linkedin.com/in/kolusu

[harikiran2001]

Thanks Kosulu,
The master file record length is 600 and is fixed . The key in the master file start at location 46 and its length is 9.

The look up file record length is 80 and is fixed. The key in the look up file starts at location 1 and its length is 9.

The format of the key is character.

[kolusu]

harikiran2001,

The following DFSORT/ICETOOL JCL will give you the desired results

[harikiran2001]

Its working.....Thanks a lot Kolusu...............