Cannot Rollback changes when loading to ODBC stage
Posted: Wed May 09, 2007 1:36 am
Hi !
I am loading files from sequential file to a target database.
Target as DB2:
If there is an error I am able to roll back the changes made by entering the Transaction Size as 0 and Array Size = number of records being loaded.
Is this correct ?
Target as ODBC
When I use this stage I am not able to roll back the changes.
I did specify the Rows Per Transaction to 0 and several test cases for Parameter Array Size ranging from 0 onwards..
PLease advice...
Thanks
I am loading files from sequential file to a target database.
Target as DB2:
If there is an error I am able to roll back the changes made by entering the Transaction Size as 0 and Array Size = number of records being loaded.
Is this correct ?
Target as ODBC
When I use this stage I am not able to roll back the changes.
I did specify the Rows Per Transaction to 0 and several test cases for Parameter Array Size ranging from 0 onwards..
PLease advice...
Thanks