Commit/Rollback from Datastage
Moderators: chulett, rschirm, roy
Commit/Rollback from Datastage
While loading Lacks of records into the target,i need to commit, say after every 50 records ...How can i do this While loading data into the Target using Datastage.
What database?
There should typically be a tab on the stage you are using for 'Transaction' control. One of the fields should be 'Transaction Size' - set this to 50 to commit every 50 records.
That being said, recognize the fact that this will complicate your restart strategy.![Wink :wink:](./images/smilies/icon_wink.gif)
There should typically be a tab on the stage you are using for 'Transaction' control. One of the fields should be 'Transaction Size' - set this to 50 to commit every 50 records.
That being said, recognize the fact that this will complicate your restart strategy.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Suma,
When one selects 'Auto-commit' as the isolation level in Transaction Handling tab of an ODBC stage, each write is committed separately. But,
in order to perform 'Commit' after a specified number of records, one must specify the number in 'Rows per transaction' field, provided in the same tab.
Regards,
Bhanu.
When one selects 'Auto-commit' as the isolation level in Transaction Handling tab of an ODBC stage, each write is committed separately. But,
in order to perform 'Commit' after a specified number of records, one must specify the number in 'Rows per transaction' field, provided in the same tab.
Regards,
Bhanu.