Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
find those records having both -ve & +value in binary fi

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 113
Location: Bangalore

PostPosted: Sun May 11, 2008 10:06 pm    Post subject: find those records having both -ve & +value in binary fi
Reply with quote

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
View user's profile Send private message
References
PostPosted: Sun May 11, 2008 10:06 pm    Post subject: Re: find those records having both -ve & +value in binary fi Reply with quote

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 1117
Location: At my desk

PostPosted: Sun May 11, 2008 10:20 pm    Post subject:
Reply with quote

Posting the error would have helped......
Have you looked at the difference between FI & BI formats?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4133
Location: San Jose, CA

PostPosted: Mon May 12, 2008 5:23 am    Post subject:
Reply with quote

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
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 113
Location: Bangalore

PostPosted: Wed May 14, 2008 9:40 pm    Post subject: Reply to: find those records having both -ve & +value in
Reply with quote

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


-Ajay
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1