Is Informix transaction logging required?

Problem

---

When I use the DBTools.h++ Access Library for Informix with transaction logging disabled on my database, I get a server error, -261. Must transaction logging be enabled to use DBTools.h++?

---

Cause

---

Many of the features in DBTools.h++ (such as beginTransaction(), commitTransaction(), and rollbackTransaction()) require transaction support on your database. In addition, DBTools.h++ internally uses your database's transaction features for other purposes (RWDBCursor is one example). If you receive this error (-261), this usually means you have used a feature that requires transaction logging to be enabled.

---

Action

---

If you aren't using transactions in your application with version 2.x, it should be safe to ignore these -261 errors. One caveat, however, is using the RWDBCursor class. An RWDBCursor created for writing requires transaction support on Informix.

Otherwise, if you need to use transactions in your application, transaction logging must be enabled on your database.

For version 3.x, non ANSCII complient databases must be used with transaction logging enabled.