Delete from DB2 Table

condond · Post by **condond** » Wed Mar 07, 2007 11:07 am

This is a VERY basic question. How do I perform a delete using DB2_API Stages or any other staes , using what would be a normal subselect in SQL
ex: Delete from A where col1 in ( select col2 from B)

DSguru2B · Post by **DSguru2B** » Wed Mar 07, 2007 11:11 am

Welcome Aboard

You can do this in any database stage in before/after sql tabs. The sql will be whatever works for you.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 07, 2007 12:33 pm

How about a simple job that selects COL2 from B, and then uses user-defined SQL to DELETE FROM A WHERE COL1 = ?

condond · Post by **condond** » Wed Mar 07, 2007 1:11 pm

I guess its true - We overthink everything the answeres were great thanks

DSXchange

Delete from DB2 Table

Delete from DB2 Table

Thanks for your help