Re: Can I store every sql stmt executed whe using dbaccess?

Posted in 2000

Mark D. Stock — Tue, 02 May 2000 22:29:05 +0100 — source: Informix-list mailing list archive (1991-1998)

Rudy Fernandes wrote: > > Ramon Marquez wrote: > > > Hello > > > > What I want to know is if there's a way to know each and every sql > > statement that has been executed via dbaccess against a given database > > > > TIA > > You could, by running 'SET EXPLAIN ON;' at the start of your dbaccess > session (you will get additional information as well, though). With a severe loss of performance of course. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+