anilgm007 wrote: > > When I start a session1 as : > > /opt/sapdb/depend/bin/xsql -z -d ODL -u posuser,posuser > > insert into tmptable values(20) > * Ok > > > > > > In another terminal I start another session2 as : > [root@twix root]# /opt/sapdb/depend/bin/xsql -z -d ODL -u > posuser,posuser > > select * from tmptable > A | > ----------------- > 1 | > 2 | > 3 | > > > > The secont query hangs till the REQUEST_TIMEOUT expires or I commit > the transaction in session1. > As far as I know in isolation level 1, I supposed get the uncommited > data in session2 when I query the table > without a wait. is there any way to do this in SAPDB ? >
You have to use isolation level 0 (uncommited) to read uncommited data. With isolation level 1 (read commited) only commited data could be read. For more information see http://www.sapdb.org/htmhelp/5e/eba667440a11d3a98200a0c9449261/frameset.htm Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
