Re: MODE ANSI DATABASES

: > Does anybody know where I might find some kind of list to detail the : > differences between standard transaction logged databases and mode : > ANSI databases. : With MODE ANSI, you have unbuffered logging and you are always in a : transaction. You COMMIT or ROLLBACK, and you're automatically put : into a new transaction. True. And isolation mode defaults to repeatable read. Something that can get you in a lot of trouble if you have users who might do something like: 1. open a dbaccess window 2. select * from table; 3. go to lunch. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.