View previous topic :: View next topic
|
Author |
Message |
mf_karthik
New User
Joined: 26 Jul 2005 Posts: 55
|
|
|
|
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 |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|