Re: Change of Logging Status: Implications?

Peter Tashkoff (TASHKOP@kiwi.co.nz) wrote: : I would have thought that the 4gl programs would : not be bothered by a move to transaction logging as : Informix treats each sql statement as a singleton : transaction anyway, so it should make no difference. It does make a difference. Cursors FOR UPDATE can only be opened inside a transaction, for example, when the database is changed to logging mode. Cursors are automatically closed at the end of a transaction unless declared WITH HOLD. Locks are automatically freed at the end of a transaction, can only be placed inside a transaction, and the UNLOCK statement must be outside a transaction. I'm worried about other implications that I don't know of. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+