Create file with non-matching records

oerdgie · New User Joined: 22 Nov 2007 Posts: 64 Location: Germany

Hi,

could anybode help me to solve the following problem ?
I like to create a file with non-matching records :

File 1 contains only no duplicate keys on pos. 1 to 3.
File 2 contains data including a duplicate key on pos. 4 to 6.
I need an output file containing all record from file 2 with non-matching keys from file 1.

Exampel :

oerdgie · New User Joined: 22 Nov 2007 Posts: 64 Location: Germany

Sorry for the shifting in the exampel, here once more :

file 1
------
AAA
BBB
CCC

file 2
------
100AAAaa
400DDDd1
101AAAaa
200BBBbb
401DDDd2
500EEEee

output file
------------
400DDDd1
401DDDd2
500EEEee

smijoss · Active User Joined: 30 Aug 2007 Posts: 114 Location: pune

have you tried reading JOINKEYS for DFSORT

oerdgie · New User Joined: 22 Nov 2007 Posts: 64 Location: Germany

Thanks, I tried JOINKEYS, it's new for me...
but it works perfectly for my problem

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

oerdgie,
So did you get desired results or do you still need something be done?

Thanks,

oerdgie · New User Joined: 22 Nov 2007 Posts: 64 Location: Germany

Hi sqlcode1,

thanks for asking, now get my desired results.

Regards oerdgie