Re: ANSI vs. Non-ANSI

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. June ---- June Tong Informix Software ---- ---- junet@informix.com On-Site Regency Support at SAP ---- ---- Informix: (415)926-6140 SAP: (415)286-6808 ----