DSXchange

Hi,

Iam having a requirement like this . Iam getting a message and it was parsed by xml and Iam inserting or updating or deleting the records in DB2 API stage . After entire XML message has been processed (i.e either inserted or updated or deleted ) then I need to commit the table. I read in some posts that I can use APT_RDBMS_COMMIT_ROWS and is there any option in stage DB2 API like transaction size.Can I use transaction size to commit the rows.If Iam wrong correct me


Thanks
Somaraju

The commit frequency is the transaction size in your stage.

The commit frequency as mentioned by Andrw, would help you acheive the goal. The default I beleive is 1000 rows.
Most of the time you dont have rollback privelages, so decide before you commit anything.