Hi All,
Does the 'Truncate' load method in DB2 enterprise stage, issue a 'delete from <table>' command behind the scenes (mean it is logged transaction)? Or does it do a non-logged delete?
If it does a logged delete, then is there a way to do a truncate of the table before loading it from DB2 enterprise stage?
Also, I tried to give the command alter table #db2_tgt_db#.#db2_tgt_table# activate not logged initially with empty table; in the 'Open Command' of the DB2 enterprise stage, but it errored out. Is it allowed to issue this statement in the open command?
thanks
DB2 Enterprise Stage - Truncate Option
Moderators: chulett, rschirm, roy
Re: DB2 Enterprise Stage - Truncate Option
There is no specific truncate command in db2.
You can use following command in unix script.
Call that script in the before-job sub routine.
You can use following command in unix script.
Code: Select all
import from /dev/null of del replace into #tablename#
Tejas