Delete statement in DRS Stage for Oracle database

nani0907 · Post by **nani0907** » Mon Dec 13, 2010 9:19 am

Hi,

Iam using the DRS stage for delete and insert process to oracle table with update action as "Insert New rows Only" .In before tab , i need to delete based upon the incoming values . Is it possible in DRS stage. When i mention harcoded values ,it works properly.Please let me know how to delete based upon incoming values.

chulett · Post by **chulett** » Mon Dec 13, 2010 11:31 am

It is not possible to leverage any incoming row data in the 'before' or 'after' SQL tabs.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 13, 2010 2:58 pm

You would need two jobs to achieve this or, perhaps, user-defined SQL to call a stored procedure.

nani0907 · Post by **nani0907** » Tue Dec 14, 2010 7:28 am

Thanks ray..

chulett · Post by **chulett** » Tue Dec 14, 2010 7:32 am

It's important to understand here that those areas are only executed once, not per row - hence their name and the problem.