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.