Page 1 of 1
Uncommitted Read
Posted: Mon Feb 12, 2007 7:16 am
by Raftsman
Is there a way to default the input DB2 reads to "Uncommitted Read"? I looked the environment variables and couldn't find the settings.
Thanks
Posted: Mon Feb 12, 2007 2:38 pm
by ray.wurlod
Are you using the Enterprise stage or the API stage?
Posted: Tue Feb 13, 2007 7:17 am
by Raftsman
We are using the Enterprise stage.
Posted: Tue Feb 13, 2007 2:20 pm
by ray.wurlod
I don't think the Enterprise stage can set ODBC transaction isolation levels. Certainly in Read mode it can not; and I don't believe it's possible using SQL either. "Read uncommitted" is an ODBC convention, at least originally. Ask your DBA if there's any setting you can make, and if there is you might execute that command as the OPEN command.