RE: Infomrix -710 errors

Posted in 2005

Konigsberg, Jay — Tue, 2 Aug 2005 15:28:44 -0700 — source: Usenet: comp.databases.informix

Are you re-preparing prepared statements in long-running processes and middleware servers after running update statistics? Often the update stats on an active table will invalidate the query plan computed when a statement is PREPAREd. The next time you try to EXECUTE such a statement or OPEN a cursor declared for it you will get a -710 error. Our middleware is coded to just reprepare the statement and try the EXECUTE/OPEN again when it gets -710. Possible, we're looking into it. Thanks, Jay sending to informix-list

Related threads

informix error question
Reusing same Cursor name help (errors 710 and 4371)