find those records having both -ve & +value in binary fi

Ajay Baghel · Posted: Sun May 11, 2008 10:06 pm

Hi,

I have a file containing a large no of records each with 600bytes length. I am concerned with first 8 bytes only which contain S9(15) COMP data.

I want to find only those records which have negative value as well as +value for a particular no in this field.

for eg:

i tried:
//sysin dd *
include cond=(1,8,bi,eq,-222229334,or,1,8,bi,eq,222229334)
sort fields=copy
/*

I got some format incompatible error message. How can i get my records?

I can not use OUTREC or INREC with EDIT feature because i do not want to increase the record length i the output file and since the no of records may be large also.

-Ajay

CICS Guy · Posted: Sun May 11, 2008 10:20 pm

Posting the error would have helped......
Have you looked at the difference between FI & BI formats?

Frank Yaeger · Posted: Mon May 12, 2008 5:23 am

Ajay,

BI is unsigned binary, so comparing a BI field to a negative value is invalid ... that's the reason for the error message. FI is signed binary - that's what you want to use:

Ajay Baghel · Posted: Wed May 14, 2008 9:40 pm

Thanks CICS guy and Frank. I tested it and i am getting it.

-Ajay