Re: SE: Can't drop transaction logging

>>>>> On Wed, 13 Apr 1994 11:52:38 GMT, spitz@GANS1X.ana.med.uni-muenchen.de (Richard Spitz) said: > In a SE 4.1 database, I just discovered that the person who created > it used only a relative pathname for the transaction log file. This > makes it impossible to access the database from other directories. > I wanted to change that following the description in the 4.0 SQL manual. > I logged in as the DBA for that database and tried to issue the > following SQL command: > DELETE FROM systables WHERE tabname = "syslog" > This produces an error "No delete privilege". When working on system tables DBA privilege is not enough. Try these things while being logged in as "informix". > What's going on here? Is there a possibility how I can drop transaction > logging on this NON-ANSI SE database in 4.1? Seems like you really do not want to drop transaction logging, but change to another log file instead. If this is true, you might want to try START DATABASE db_name WITH LOG IN "pathname"; Hope this helps. -- Oliver Okrongli infix Software-Systeme GmbH Phone +49 531 238090 Rebenring 33 Fax +49 531 2380935 oliver@infix.de 38106 Braunschweig F.R. Germany