Including condtion in Outrec

khamarutheen · Posted: Fri May 30, 2008 8:43 pm Post subject: Including condtion in Outrec

Hi all,

I have a 1000 records in a file, i need to write a jcl such that those 1000 records should be omitied in the output file. writing sort card with 1000 omit condition is really hectic. is there any alternate way to write those 1000 records in a seperate sort card? please instruct. Let me know if my requirements is not clear

CICS Guy · Posted: Fri May 30, 2008 8:56 pm Post subject:

OUTFIL OMIT=ALL?

khamarutheen

No buddy, i cant use omit. Let me explain my requirement in detail.

we have a input file with 5000 records. we need to omit 1000 records which customer says. the report should return only 4000 records. but the customer requirements differs. it may be 1000 or 30 or even 1. So if it's 10 or 20 it's easy to write sort card. if it goes 1000 or above, how do we repeat the omit statement for different account numbers???

enrico-sorichetti

that' s the classic two file match problem

search the forums ( jcl or dfsort )

arcvns · Posted: Mon Jun 02, 2008 6:31 pm Post subject:

Hi khamaurutheen,

Which Sort product r u using?....

arcvns · Posted: Mon Jun 02, 2008 6:41 pm Post subject:

Hi khamaurutheen,

If you have the accnt nos. to be omitted in another file, you can try out the below JCL after changing the file attributes as per your requirement.