Re: Informix error -346

Hal van den Assem <HalVanDenAssem@unn.unisys.com> wrote: :An ESQL/C program, which processes a huge amount of data in one :single transaction, causes the SQL-error Code -346. : :I use Informix-SE INFORMIX-SE Version 7.10.UD1, on a Unisys :SMP5400 Unix machine. : :Could someone confirm or explain that the error is caused by :a 'too large' transaction!? :How can I determine the size of a transaction, and how to put more :updates and inserts into 1 single transaction!? (enlarge a transaction) :If possible, I do not want break-down the workload into smaller :transactions. On my installation finderr 346 says: -346 Could not update a row in the table. While processing an UPDATE, the database server received an unexpected error. Check the accompanying ISAM error code for more detailed information on the cause. Possible causes include hardware errors and locking conflicts. So how about giving us that isam error. You may have any number of errors. It's not to usefull to speculate too much without the appropriate data available. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org