How to read uncommited data in the same Unit of Work.

pkumarnair · #1 (**permalink**) 08-23-04, 19:09

I have a process in which I do some updations to different tables and these uncommitted tables have to be read again for some other updations. My problem is that each time I use a "Select" I get the previous comitted data instead of the uncomitted data which I need.

I Understand one option is to do a Uncomitted Read on the table. Do I have any other alternative to this problem.

Please assist

sathyaram_s · #2 (**permalink**) 08-25-04, 13:02

I'm surprised ....

grofaty · #3 (**permalink**) 08-26-04, 01:45

Hi, pkumarnair

Please specify the db2 version and fixpack level and operating system and fix level.

Please also read Must Read before posting

Hope this helps,
Grofaty

pkumarnair · #4 (**permalink**) 08-26-04, 13:14

Thank you grofaty for responding.

I am working on Mainframe OS/390 and am not aware of the Fixpack leveland fix level that you asked.

However the DB2 for OS/390 version is 7.1

I hope this helps you

Regards
Prad

Internet Services

Web Development

Digital Marketing

Consumer Tech