Clear the rows before inserting depending on non key coloumn

chulett · Post by **chulett** » Mon Oct 06, 2008 9:56 pm

Yes, you are confusing us.

You always need to delete records where those three columns have those three values regardless of the input data? Or you need to delete those values because they are in the input data? The former calls for hard-coding and the latter calls for getting your delete syntax correct.

dsdevper · Post by **dsdevper** » Tue Oct 07, 2008 10:01 am

Yes I have to delete the rows in the target with those hard code values regardless of incoming data..

Thanks
Suman.

chulett · Post by **chulett** » Tue Oct 07, 2008 10:08 am

Then why not simply put a delete statement for those values (same as you would run in Toad or sqlplus) anywhere that runs before the main stage actions. For OCI, 'before sql'. For the Enterprise stage, in the 'Open' statement area I would guess.

dsdevper · Post by **dsdevper** » Thu Oct 09, 2008 2:23 pm

Thanks SURA and Chullet,

It solved my problem.I wrote simple sql query in before tab in db2 satge.

Thanks very much.