View previous topic :: View next topic
|
Author |
Message |
pjnithin
Active User
Joined: 22 Dec 2005 Posts: 116
|
|
|
|
Can i get the unmatching records from two inputs to an output file by splice or a normal sort.
Input1 :
111 abcd
111 cdef
222 acfg
Input2 :
111 mnop
333 acfg
My output should be like
111 abcd
111 cdef
i;e the output file shud contain only those record from the input file which has got a matching key(here first 4 chars) in the second file. Please let me know whether this can be done by a normal sort or if there is a way of using the splice function please let me know that also.
Thanks,
Nithin. |
|
Back to top |
|
|
pjnithin
Active User
Joined: 22 Dec 2005 Posts: 116
|
|
|
|
Here I also need to get the unmatching records in another file. Like,
Input1 :
111 abcd
111 cdef
222 acfg
Input2 :
111 mnop
333 acfg
unmatch records output file:
222 acfg |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
Back to top |
|
|
pjnithin
Active User
Joined: 22 Dec 2005 Posts: 116
|
|
|
|
Priyesh,
It worked, but what does KEEPNODUPS option makes. I was trying without that, like:
SPLICE FROM(T2) TO(OUT) ON(1,13,CH) WITHALL -
WITH(81,3) USING(CTL4)
But in this cases only the matching records were spliced and coming in the output. None of the unmatched records from either of files 1 or 2 was not coming in the output.
Anyways thanks for ur help.
Nithin.
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
Back to top |
|
|
|