delete records from table
Posted: Tue Feb 21, 2006 4:56 pm
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
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