Re: ESQL/C Problem with more then 62 deletes in transaction

You don't give a version, but I am quite sure you hit the same limit we did in a similar situation. It's something with the number of tables that can be accessed simultaneously. We moved most of the code into stored procedures and got it to work fine. Oliver Heiwig <ohe@sbk-ks.de> wrote: :We 've to delete in about 120 Tables, this must be within one :transaction. But always after 62 Deletes the program make mistakes with :errorcode -242, independent from the order of the delete statements. :If I put the statements in 3 transactions each with 40 Tables it works. : :Does anybody know a solution? : :Thanks Oliver : : :-- : Dipl.-Ing. | SBK Software + Systeme GmbH : Oliver Heiwig | Hollaendische Strasse 141 : Email : ohe@sbk-ks.de | D-34127 Kassel : Phone : ++49-(0)561-9899-742 | Germany : Fax : ++49-(0)561-8 51 61 | http://www.sbk-ks.de/ 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