Re: ANSI vs. Non-ANSI

On 6 Jan 1995, June Tong wrote: > In article <dberg.789147595@cheetah> dberg@informix.com (David I. Berg) writes: > >Third, the isolation level for applications running against ANSI databases > >defaults to Repeatable Read. This can wreak havoc with concurrency > >control and lock management. (With Repeatable Read every row selected > >within a cursor has a shared lock placed on it from the time the first such > >row is fetched until the cursor is closed.) > > > Of course, you can always change the isolation level within your application, > but just wait until the first time someone runs: > SELECT * FROM sometable;> and then goes to lunmch. > Point taken. Question: Shouldn't then that Online has some form of timer that will release a lock after some time, and return a error message to the process that place the lock?? BTW, isn't it a MUST to log out of your terminal when you are going for lunch, I mean security and all that :-) Seriously, has anyone written an application that will exit gracefully after being inactive for a certain period of time?? ========================================================================= Calvin Ng should I include the disclaimer?? It goes on for five pages! :-) Anyway, the short version: I, and only I, am responsible for what I said. =========================================================================