| Author |
Message |
Ajay Baghel
Active User
Joined: 25 Apr 2007 Posts: 95 Location: Bangalore
|
|
|
|
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 |
|
| Back to top |
|
 |
References
|
Posted: Sun May 11, 2008 10:06 pm Post subject: Re: find those records having both -ve & +value in binary fi |
 |
|
|
 |
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 1002 Location: At my desk
|
|
|
|
Posting the error would have helped......
Have you looked at the difference between FI & BI formats? |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005 Posts: 3804 Location: San Jose, CA
|
|
|
|
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:
| Code: |
INCLUDE COND=(1,8,FI,EQ,-222229334,OR,1,8,FI,EQ,222229334)
SORT FIELDS=COPY
|
|
|
| Back to top |
|
 |
Ajay Baghel
Active User
Joined: 25 Apr 2007 Posts: 95 Location: Bangalore
|
|
|
|
Thanks CICS guy and Frank. I tested it and i am getting it.
-Ajay |
|
| Back to top |
|
 |
|
|
|