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

File matching using specific condition


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mf_karthik

New User


Joined: 26 Jul 2005
Posts: 55

PostPosted: Fri Nov 20, 2015 11:04 pm
Reply with quote

I need to compare a flat file with vsam file using a specific key then need to fetch the matched records from flat file only when particular column is spaces in Vsam file.

file matching i'll do with the joinkeys and i would like to know how to fetch the records by a particular condition.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Fri Nov 20, 2015 11:15 pm
Reply with quote

You can use the INCLUDE condition on JOINKEYS statement.
Code:
JOINKEYS FILE=F1,FIELDS=(1,5,A),
INCLUDE=(6,1,CH,EQ,Cā€™ ā€™)


.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2578
Location: NYC,USA

PostPosted: Fri Nov 20, 2015 11:19 pm
Reply with quote

Are you looking just for include or omit?
www-01.ibm.com/support/knowledgecenter/SSLTBW_2.1.0/com.ibm.zos.v2r1.icea100/ice2ca_JOINKEYS_statements.htm
You could have searched over here by yourself ,
ibmmainframes.com/viewtopic.php?t=61905&postdays=0&postorder=asc&start=0
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Sat Nov 21, 2015 12:08 am
Reply with quote

You can specify INCLUDE=/OMIT= on the JOINKEYS statement, but the advice is not to do that:

DFSORT Application Programming Guide wrote:
Although the INCLUDE and OMIT operands are available on the JOINKEYS statement, it is recommended that you specify an INCLUDE or OMIT statement in JNF1CNTL or JNF2CNTL instead for ease of use.
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 Writng matched records into output fi... DFSORT/ICETOOL 9
No new posts Compare the file record count percent... DFSORT/ICETOOL 4
No new posts compare two file to find position/dat... SYNCSORT 2
No new posts Converting a file from PD to display ... SYNCSORT 4
No new posts Matching and non matching records usi... DFSORT/ICETOOL 11
Search our Forums:

Back to Top