hi,
i have two inputs, both are sequential files with datatypes varchar
i need one output in sequential file with datatype varchar
my input1:- sequential file
col1 col2 col3 col4 col5........col10
111 80 0001
111 80 0002
111 80 0003
222 84 9301
222 84 9302
222 84 9501
222 84 9502
222 84 9701
333 84 9101
444 80 0001
555 84 9301
555 84 9302
555 84 9303
input2: SEQUENTIAL FILE
col1 col2 col3
111 80 0001
222 84 9301
333 84 9101
444 80 0001
555 84 9301
my ouput:- SEQUENTIAL FILE
col1 col2 col3 col4.....col10
111 80 0002
111 80 0003
222 84 9302
222 84 9501
222 84 9502
222 84 9701
555 84 9302
555 84 9303
i need to get the difference out of two inputs. i.e i need all the rows that are not common in these two inputs.
please help
thank you
how to get the difference out of two sets
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: