View previous topic :: View next topic
|
Author |
Message |
harish5002
New User
Joined: 21 Jul 2010 Posts: 23 Location: chennai
|
|
|
|
Hi All,
I have the requirement that i need to compare two fields(columns) in the same file and write the unmatched(not equal) records to output file through JCL. Is it possible to do through JCL. I have searched in internet and i got comparing to files i did not get comparing two fields in the same file. Please anyone help me regarding this. Thanks in advance to all.
EX:
Input file:
A B
(108-109) (736-737)
11 12
11 11
10 10
10 10
10 10
10 10
10 10
10 10
10 10
10 11
OUTPUT FILE SHOULD BE;
D E
(108-109) (736-737)
11 12
10 11 |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
do not tag new questions to unrelated ongoing topics...
topic has been split |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
So I noticed, enrico... :-)
It is a simple answer, so I feel either I'm missing something or you, harish5002, should read up on the capabilities of INCLUDE/OMIT.
Code: |
OMIT COND=(108,2,CH,EQ,736,2,CH) |
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
if the ts had searched the forums, he would not have had the need to ask ...
searching with field compare same record in the dfsort section returned 47 hits |
|
Back to top |
|
|
harish5002
New User
Joined: 21 Jul 2010 Posts: 23 Location: chennai
|
|
|
|
Sorry to post for existing tag line enrico-sorichetti.
Thanks Bill Woodger for your quick response. I tried and it worked. I am trying to write specific fields into output file by using outrec.
Any way thanks very much for your quick response. |
|
Back to top |
|
|
|