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

From: "Jim Maus" <jim.maus@eds.com> > >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? Someone did something. We had this on a similar platform, where I work yesterday, when someone, who shall remain nameless, forgot that people were doing this kind of thing and did an ALTER TABLE xxx LOCK MODE (ROW).... <blush> ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com