how to get the difference out of two sets

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pattemk
Participant
Posts: 84
Joined: Wed May 16, 2007 4:04 pm

how to get the difference out of two sets

Post by pattemk »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What have you actually tried? My first thought would be to use Difference stage to determine a difference.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply