Re: Set Lock to Wait ???

In article <01bded9a$a84543a0$e74689d0@rgriffin>, "RG" <rgriffin@farmerstel.com> wrote: > If you are talking about "set lock mode to wait", this only waits if a > table has a lock on it. If it > is not waiting, then that is good, there is no lock....otherwise there is a > lock and your statement will wait until the lock is released. > > regards, > Robert Thanks, the problem is solved now, it was that I put the set lock mode to wait inside de transacion and not before the "begin work". My confusion was with Oracle that you put nowait en each select, here it seems that the wait/nowait is for evrey transaction until I change explicitly. Thanks again. Eduardo. > > ecominguez@my-dejanews.com wrote in article > <6uu933$fvr$1@nnrp1.dejanews.com>... > > I don't know what I am doing wrong way, but I am trying to use the SELECT > FOR > > UPDATE statement (using the informix jdbc driver) and I need the wait > "on". > > It is not working, my select doesn't wait a single second, I don't know > how to > > fix it. > > Could anybody help me ?. > > Thanks. > > > > -- > > Eduardo > > Buenos Aires > > Argentina. > > > > -----------== Posted via Deja News, The Discussion Network ==---------- > > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > > > > -- Eduardo Buenos Aires Argentina. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own