RE: -710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20

We also had this problem and figured out that when we did a HPL it changed the constraints and indexes, loaded the data and then changed the constraints and indexes back to what they were defined originally. -----Original Message----- From: Art S. Kagel [SMTP:kagel@bloomberg.net] Sent: Wednesday, May 19, 1999 12:42 PM To: informix-list@iiug.org Subject: Re: -710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20 Jim Maus wrote: > > My multi-threaded Informix esql process received a -710 (table-name has been > dropped, altered, or renamed) error. The process was using a prepared > statement to fetch using a cursor. The source table was not dropped, > altered, or renamed. I can't reproduce the problem. Subsequent runs of the > code work just fine. > > Any ideas on what to investigate here? Are others getting occasional & > misleading -710 error messages in multi-threaded processes with Informix > 7.24 UCX5 on HP-UX 10.20? See Obnoxio's message for one possibility. Others: CREATE ... TRIGGER ON ... UPDATE STATISTICS MEDIUM/HIGH if it creates a distribution that did not exist before. CREATE INDEX ... DROP INDEX ... ALTER FRAGMENT ... ALTER INDEX ... TO CLUSTER/NOT CLUSTER and a few other commands can all cause a prepared cursor to become no longer valid and return a -710 on execution. It is best to have any long running program that depends on cursors reprepare and reexecute if it receives -710. Art S. Kagel