filtering a comp field using a sort jcl

jemonthomas · New User Joined: 24 Jul 2006 Posts: 35 Location: india

I have to filter out a binary field ie comp value from a file. The field is an account number.

I have to filter account number with values 15,22,200.can u please tell me how to write the include statement in sort jcl

Garry Carroll · Posted: Fri Apr 03, 2009 2:27 pm

INCLUDE FORMAT=BI,COND=(pos,len,EQ,1522200)
or
OMIT FORMAT=BI,COND=(pos,len,EQ,1522200)

should do, depending on what you mean by 'filter out'.

Garry.

jemonthomas · New User Joined: 24 Jul 2006 Posts: 35 Location: india

thanks a lot

CICS Guy · Posted: Fri Apr 03, 2009 4:27 pm

Generally, the FI would be more accurate than the BI....
FI
(fixed-point, signed). The complete number is represented by its binary equivalent with the sign indicator placed in the most significant bit position.
BI
(binary unsigned). Any bit pattern.

Ashish Ranjan · New User Joined: 12 Jan 2009 Posts: 2 Location: pune

But as mentioned on the top of discussion field is an ACCOUNT NUMBER. Could not be negative. So I think better to use Data format as BI only.