Page 1 of 1
Commit/Rollback from Datastage
Posted: Tue Jun 15, 2004 6:33 am
by suma
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.
Posted: Tue Jun 15, 2004 6:43 am
by chulett
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.
Posted: Tue Jun 15, 2004 9:42 pm
by suma
What does the auto-commit in Transaction Handling tab of an ODBC stage do?Can i use Auto-Commit option to commit after loading every 50 records into my Oracle Database.I dont find any other option to specify the same!Can any one explain me how to proceed with this!
Posted: Tue Jun 15, 2004 11:01 pm
by mandyli
If you give "auto-commit" automatically commit after each transaction (like insert or update or delete). This is not good idea b'cus commit and rollback will not under our control.
So based on you database and situation u will set the Transaction' type...
Posted: Wed Jun 16, 2004 1:47 am
by acb
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.