We are setup using DB2 connect to connect to our AS400 and whenever I try and query a file that has a record lock on a file it gives a deadlock/timeout error.

I assume that I can change it to use SQL and issue a FETCH ONLY command but is there a way to do the same using TABLE FILE syntax?

Or is there something I can change in the DB2 connect software to issue only fetch only commands?

Eric

Have you tried the SET ISOLATION command

http://techsupport.informationbuilders.com/sps/92091020.html

M

Look promising, I was looking through their techsupport for almost an hour and didn't see that.

I'll give it a try and post back, thanks!

Should be able to configure the adapter in the web console to either RC (Read committed) or RU (Read uncomitted). As Mickey mentioned, this should take care of the problem.

Another option (the longer way around) is to write SQL queries where you can add the FOR FETCH ONLY and use SQL passthru.