Hi
I have loaded data into tables through SQL Server as a Stage in Datastage.
Now i need to delete the data and reload with new data.
I actually use toad to view data and stuff...
So can I just write in the toad the delete statement for that particular table and execute.... the table also consists of other data along with the i need to delete. Will it effect the other data too or should that work ?
thanks for the help
aschand
delete data in SQL Server using TOAD loaded by Datastage?
Moderators: chulett, rschirm, roy
You will delete whatever rows fall under the WHERE in your delete statement. There's no knowledge in a database of how, when, or why data is loaded into a table unless those attributes are in the table and thus you could qualify your delete's WHERE clause accordingly.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle