with datastage i have loaded the data into SQL Server table.
i want to run datastage again and relaod it...
Now how do i delete the existing data which is present in the table and reload...
it does also have the data came from other source
i should be able to delete only my data that i have loaded
thank you
how to delete the existing data and reload it again
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Plan ahea
d
You must incorporate this functionality from the beginning, by having some way of identifying which run loaded every row in the target. This might be a unique run ID, a timestamp, or anything else you can imagine. Use its value in the WHERE clause of a DELETE statement, perhaps executed as an Open command.
d
You must incorporate this functionality from the beginning, by having some way of identifying which run loaded every row in the target. This might be a unique run ID, a timestamp, or anything else you can imagine. Use its value in the WHERE clause of a DELETE statement, perhaps executed as an Open command.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: how to delete the existing data and reload it again
Forget DataStage for the time being. How would you delete those rows from your SQL Server target?aschand wrote:i should be able to delete only my data that i have
gateleys