Hello All,
Apologies if this topic is covered earlier. I searched for the answers before posting but didn't find any. I want to know how we delete the records from the table using datastage job. I mean I have a table I want to delete some data based on some of the filter conditions. Source and target is the same table. I know it can be easily achieved using the shell script but I want to know how it is possible in datastage.
Thanks for all the inputs
-RCil
delete records from table
Moderators: chulett, rschirm, roy
delete records from table
Thanks,
RCil
RCil
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can use user-defined SQL; you job must provide values for the key columns that identify the rows to be deleted, and you include a parameter marker for each in the WHERE clause of your SQL. Make sure that the SELECT operation is complete before you perform any DELETE, otherwise you might introduce a deadlock in the database.
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.