How to load a DB2 table with Dummy?

Titto · Post by **Titto** » Tue Jul 05, 2005 8:16 am

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

elavenil · Post by **elavenil** » Tue Jul 05, 2005 9:26 am

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

Sreenivasulu · Post by **Sreenivasulu** » Wed Jul 06, 2005 3:04 am

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

Regards
Sreeni