Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
View previous topic :: :: View next topic  
Author Message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
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

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

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: 7130
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: 205
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts resume binary ftp in z/os meykh2014 All Other Mainframe Topics 2 Sun Jan 22, 2017 10:01 am
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us