NOT IN TRANSACTION

Look at the ontape command: ontape usage: { -a | -c | -l | -p | -r [-D DBspace_list] | -s [-L archive_level] [-A database_list] [-B database_list] [-N database_list] [-U database_list] } -a Automatic backup of logical logs -c Continuous backup of logical logs -l Logical restore -p Physical restore for HDR -r Full restore DBspaces/BLOBspaces as listed -s Archive full system -A set the following database(s) to ansi logging -B set the following database(s) to buffered logging -N set the following database(s) to no logging -U set the following database(s) to unbuffered logging What you would need would be the -A, -B, or -U options for each database in your instance that needs logging, depending on the logging requirements for the database. John Carlson Informix DBA WHSmith USA T.Jalaludeen wrote: > > Author : Jalal > E-mail : jala@hpsgm99.sgp.hp.com > > Question : When I use a BEGIN WORK, COMMIT WORK in my 4gl code, I get an > error saying "TRANSACTION NOT AVAILABLE" > I am using Informix -Online Dynamic Server > > How do I turn on the transaction logging.

Author : Jalal E-mail : jala@hpsgm99.sgp.hp.com Question : When I use a BEGIN WORK, COMMIT WORK in my 4gl code, I get an error saying "TRANSACTION NOT AVAILABLE" I am using Informix -Online Dynamic Server How do I turn on the transaction logging.