Re: Pls. Help with Informix-SE v5 turning off trans. log.

Posted in 1998

Howard Soper — Mon, 05 Jan 1998 19:22:21 +0000 — source: Informix-list mailing list archive (1991-1998)

DELETE FROM SYSTABLES WHERE TABNAME = "syslog" You could also look for the row with a tabtype of "L" ( I think ). If you don't have permissions to access systables, try as informix and/or grant permissions Hope this helps. Regards Howard Zoltan Luspai wrote: > Hi, > > Please help, I have problem with turning off (removing) the > transaction log from an INFORMIX-SE ver 5.05.UC1. I have tried the sql > command: START DATABASE <dbname> WITH NO LOG , but the dbaccess only > gives me a 201: syntax error message. > > Tia, > Zoltan Luspai