DB2 lock

[caola]

Hi guys,

I use DB2 API stage as target stage and choose "clear the table then insert rows".

What does DS do on this action? Does it execute below 2 sqls separately?
Delete from XXX table;
Insert into XXX table;

Will DS keep the table lock between these 2 sqls? or it will release the lock after delete and get it back again when insert?

Thanks for any comments.

[MT]

Hi caola,

DataStage will use the two statements - a delete and a insert
but I am not sure about the size of the transaction.