Re: Turnning off the Log option

In <1993Jul8.195655.15583@informix.com> davek@somerset.informix.com (Dave Kosenko) writes: >Bob Baskett writes: >|> Yair, >|> >|> logging can be turned off using the tbtape routine with online. the standard >|> engine allows you to turn transactions on, but once they have been set on, >|> you cant turn it off. >While there is no explicit command to turn logging off using SE (there will be >in 6.0), you can do the following: > delete from systables where tabtype = "L"; >which will turn loggin off for the database. But isn't there at least one version floating around (4.10.something?, or was it the early 5.00 ports?) which refuses privilege to do this even to informix? graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.