Uncommitted Read

Raftsman · Post by **Raftsman** » Mon Feb 12, 2007 7:16 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 12, 2007 2:38 pm

Are you using the Enterprise stage or the API stage?

Raftsman · Post by **Raftsman** » Tue Feb 13, 2007 7:17 am

We are using the Enterprise stage.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 13, 2007 2:20 pm

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.