commitment control AS400 / ODBC

josy · Post by **josy** » Thu Feb 12, 2004 1:14 pm

Hi all,

I am trying to delete data on AS400 using an ODBC connection.
But it seems that my job is only committed the transaction at the end.
So, the process is locking the whole AS400 file.
I tried to change the isolation level but no results.
Any ideas...

chulett · Post by **chulett** » Thu Feb 12, 2004 1:25 pm

Don't have access to a 5.x server, but in 6.x there is a 'Rows per transaction' box on the 'Transaction Handling' tab of the ODBC stage. You could use that to issue intermediate commits.

Does it not exist in 5?