DSXchange

Hi,

How to load a DB2 table with Dummy?
I need to clean up the table before inserting new rows. Yes there is an option in DB2 stage " Clean the table, then insert rows" but i need to use "User defined Insert statement" for my requirement. I tried with DELETE statement then INSERT statement in same stage but it is not inserting the rows what process has to. So, I want to dummy/clean out the table before my process then insert rows at end of the process.

Or are they any methods!
Any help appreciated!

~T

Issue the delete statement in the Before SQL tab of the DB2 stage, then the delete statement would get executed before inserting any rows.

HTWH.

Regards
Saravanan

Plus you need to put the COMMIT if the transaction paramters are not set

Regards
Sreeni