Transaction

I am Using Informix for NT and a I have a database that uses buffered logging. When I am trying to do the following: BEGIN WORK, ... <SOME STATEMENTS> ... COMMIT WORK; This error shows up: > > -256 Transaction not available. >You cannot begin a transaction in this database because it does not have a transaction log. In order to support transactions, > you must start a transaction log. Refer to your Administrator's Guide for information on how to start a transaction log. The question here is, how do I start a transaction log in Informix for Windows NT? I do not find it in the Administrator's Guide. Thanks

Elsa Perales wrote: > > I am Using Informix for NT and a I have a database that uses buffered > logging. > When I am trying to do the following: > > BEGIN WORK, > ... > <SOME STATEMENTS> > ... > COMMIT WORK; > > This error shows up: > > > > > -256 Transaction not available. > >You cannot begin a transaction in this database because it does not have a > transaction log. In order to support transactions, > you must start a > transaction log. Refer to your Administrator's Guide for information on how > to start a transaction log. You created a database without logging. Change the logging mode of your database to "unbuffered logging": $ ondblog unbuf NAME_OF_YOUR_DATABASE Your can check the logging mode of your database with the following Select: DATABASE sysmaster; SELECT * FROM sysdatabases WHERE name = "NAME_OF_YOUR_DATABASE"; hope this helps... Regards Markus

In article <38B127C7.27963D59@mch.siemens.de>, Markus Holzbauer <markus.holzbauer@mch.siemens.de> wrote: ...> > You created a database without logging. > Change the logging mode of your database to "unbuffered logging": > > $ ondblog unbuf NAME_OF_YOUR_DATABASE Does this really mean that you can call that statment in an ESQL-Module like those statements $select, $update, .... ??? That would be very nice !!! -- cpp gcueppers@gmx.de Sent via Deja.com http://www.deja.com/ Before you buy.