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 ?
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
