Need help to cleanup table

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Posts: 7
Joined: Sun May 05, 2019 8:37 pm

Need help to cleanup table

Post by Yarobi »

Hello all,

I made a mistake and need to cleanup a table.

After run 120 I noticed my wrong join and now I need to clean duplicated data.
But I can't figure out how to do this.

Anyone who can help me a little?

In attachment I took a screenshot from my sampledata.
So I only need to keep the green lines, every time the 'UREN' changed.
Cleanup table.jpg
Cleanup table.jpg (117.62 KiB) Viewed 29262 times
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia

Re: Need help to cleanup table

Post by ray.wurlod »

In Job1 process the data and detect changes in UREN, only outputting on change.
Job 2 loads the results of Job1 into your table, probably truncating it first.
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