RE: Serialization failure 40001 or -11037

Enrique- A few things to look at: Does the table you're inserting into have an insert trigger on it? If so, is it doing something with a serial column in the row you're inserting or does it insert or update the same table you're inserting into? Is the table set to lock mode row? --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of eferreyra Sent: Thursday, February 01, 2007 11:09 AM To: informix-list@iiug.org Subject: Serialization failure 40001 or -11037 Im getting this error via ODBC next to an insert statement ... I cant see how a dead-lock can occur, and always get in the same insert of the same table. Some idea how to deal with this ? Using IBM INFORMIX ODBC DRIVER 2.90 (TC3, TC6) Thanks A.U.S. Enrique Ferreyra _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list