How to count records in JCL based on some condition.

ShobhitVerma10april · New User Joined: 28 Jun 2014 Posts: 21 Location: INDIA

Hi Bill ,

I used following syntax but its is giving me an error at OMIT

SORT FIELDS=(1,1000,CH,A)
INREC IFTHEN=(WHEN=INIT,BUILD=(1,4,93,10,986X)),
IFTHEN=(WHEN=GROUP,KEYBEGIN=(1,14),PUSH=(15:ID=5)),
IFTHEN=(WHEN=INIT,OMIT=(17,5,ZD,LE,400)) OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,15,
TRAILER3=(1,15,X,COUNT=(M11,LENGTH(5))))

Can you please correct it .

Bill Woodger · Posted: Wed Jul 02, 2014 2:53 pm

No, you are making things up. How can I correct stuff if you just make up your own syntax?

Also, what about Rohit's question? Can't do anything til you answer that.

ShobhitVerma10april · New User Joined: 28 Jun 2014 Posts: 21 Location: INDIA

Yes , that i corrected and sorted the records as you see in the card . And that issue is resolved.

Now i have to remove those records which are having count greater than 100 or anything . How can i implement it in the same card .

ShobhitVerma10april · New User Joined: 28 Jun 2014 Posts: 21 Location: INDIA

It worked with below sort card :

SORT FIELDS=(1,1000,CH,A)
INREC IFTHEN=(WHEN=INIT,BUILD=(1,4,93,10,986X)),
IFTHEN=(WHEN=GROUP,KEYBEGIN=(1,14),PUSH=(15:ID=5))
OMIT COND=(17,5,ZD,LE,00400)
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,15,
TRAILER3=(1,15,X,COUNT=(M11,LENGTH(5))))

Thanks Everyone!!!