Re: Locking problem in INFORMIX ONLINE 7.20. UC2

Infodata Ltd. (Sharjah) U.A.E. wrote: } } Hi vijay, } } Thanks for yr reply. } } The SQL U have stated will work fine if U know which particular record } record is locked. But in a live multiuser environment any user may lock } anything. And any user may fire his query anytime on any table that contains } a lock on one/more of its record. Hope U got my point. Yes, it is not practical for real life environment. Setting the isolation to dirty read is the only solution in that case, IMHO. But you can get some info. regarding the locks from the sysmaster database, but again, it may not be practical/feasible to rely that info. 'coz of its virtuality. I think at some time INTERBASE (early versions) was having that feature of skipping the locked row, again I am not sure about that. } } Thanks again for looking into the matter. } } Regards } Bharat shah. } } At 03:33 c 08/07/97 -0400, you wrote: } >Yes, if it encounters an error while reading rows, it stops the } >execution. } > } >You check the following SQL to exclude the locked row: } > select * from tab1 } > where a = '1' or ( a > '2' and a < '9') ; } > } > hope this is not one of the 'different ways' you tried. } > } > } >Infodata Ltd. (Sharjah) U.A.E. wrote: } >> } >> Dear friends, } >> } >> My problem is as follows : <snipped> } >> But does the row level lock prevent all the rows after it also to be locked. } >> I have tried this in different ways } >> but everytime it comes to a locked row it will stop & give error and will } >> not show the remaining rows. } >> } >> What I want to say is that IT LOCKS MORE THAN ONE ROW ( all rows after the } >> locked row). Is this O.K. or an bug or am I doing some mistake in } >> understanding it. Actually I was responding this part of your posting. } >> } >> Please throw some light if U can. } >> <snipped again> } >> } >> Thanks } >> } >> Bharat Shah } >> INFODATA Ltd. <snipped> -- \\\\|// Vijay R. Anisetti |6 6| -------------------oooO--U--Oooo----------------------------