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
Cannot Rollback changes when loading to ODBC stage
Moderators: chulett, rschirm, roy
Re: Cannot Rollback changes when loading to ODBC stage
Why are you 'not able to'? What happens or does not happen?cosec wrote: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
Rollback requires uncommited data and a job abort to make it happen.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thnks but when i tried with the same settings you suggested it still does not rollback the previous transactions,
For eg.
I have 3 rows to be loaded. In the second row I have a character value which will be loaded to a numeric column. In Principle it should abort the job and roll back the changes....but that doesnt happen even after the settings you suggested....any suggestions ?
For eg.
I have 3 rows to be loaded. In the second row I have a character value which will be loaded to a numeric column. In Principle it should abort the job and roll back the changes....but that doesnt happen even after the settings you suggested....any suggestions ?
rafik2k wrote:Array Size = number of records being loaded. not like that.
Parameter array size =the number of rows written at a time.
What Isolation level you set in Transaction Handling tab?
Check with defaullt value like
Isolation level=None,
Row per transaction=0
and Parameter array size=1