RE: Share Mode Locking Problem...

>I'm sorry, but my OLTP background must be different from yours. It seems } logical to me that if I issue an isolation level of "committed read" } (re: } give me only data that has been committed) on the 2nd query (the } "select"), that I should not get an error when it comes to reading a } shared locked row in the table which is being updated. I should get } the } data as it was in the table before a transaction started modifying it, } assuming that the transaction is still in progress. } } But, then again, I came from Sybase and after all, we *are* number 3. } So, } maybe Informix is right in this case? But, maybe not. *smile* } } [Frido van Orden] } Oracle works the same way as Sybase and *is* number 1 :-)