DSXchange

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.

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

Thanks
Suman.

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.

Thanks SURA and Chullet,

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

Thanks very much.