Cannot Rollback changes when loading to ODBC stage

[cosec]

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

[rafik2k]

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

[chulett]

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

Why are you 'not able to'? What happens or does not happen?

Rollback requires uncommited data and a job abort to make it happen.

[cosec]

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 ?

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