IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Retrive records based on condition


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Senthilkumar k
Warnings : 1

New User


Joined: 07 May 2009
Posts: 51
Location: Chennai

PostPosted: Tue Sep 21, 2010 2:46 pm
Reply with quote

Hi I have file like below and need to extract the records based on below condtion,

Input File,

Code:
7 bytes       2 bytes  2 bytes
1234567          34     56
4589923          12     12
6790823          56      3
4589903           6      6
4590823          34     34


Out put file
Code:

1234567     34    56
6790823     56     3

I need to compare both 2 bytes values in a record and need to extract a record which are all not matching.

Both input and output files are FB, LRECL = 80.

please help me on this.
Back to top
View user's profile Send private message
smijoss

Active User


Joined: 30 Aug 2007
Posts: 114
Location: pune

PostPosted: Tue Sep 21, 2010 2:50 pm
Reply with quote

well havent you read about OMIT or INCLUDE in sort ....
Back to top
View user's profile Send private message
nil_mf

New User


Joined: 06 Jun 2005
Posts: 29

PostPosted: Tue Sep 21, 2010 4:43 pm
Reply with quote

Hi,
Use the below sortcard

Code:
 
   SORT FIELDS=COPY
   INCLUDE COND=(18,2,CH,NE,25,2,CH)


Regards
Nil
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Tue Sep 21, 2010 10:15 pm
Reply with quote

Senthilkumar,

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
No new posts JCL sortcard to print only the records DFSORT/ICETOOL 11
Search our Forums:

Back to Top