ESQL/C Problem with more then 62 deletes in transaction

Posted in 1997

Oliver Heiwig — Tue, 01 Apr 1997 13:40:52 -0800 — source: Informix-list mailing list archive (1991-1998)

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/