Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jim Maus — — source: Informix-list mailing list archive (1991-1998)
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?
↪ replying to Jim Maus
Dragan Jurkovic — — source: Informix-list mailing list archive (1991-1998)
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?
UPDATE STATISTICS for specific table will help.
Regards,
Dragan Jurkovic
MRRM (Canada) Inc.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.