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.
"Andy Kent" — — source: Informix-list mailing list archive (1991-1998)
> My program is an ESQL C program written on HP-UX and I have a
> scroll cursor that is causing me problems.
>
> If I do a fetch current I get an error -259 in the sqlca.sqlcode
> which is supposed to mean cursor not open. But if I do a fetch
> next it works for part of the table. At some point near the end
> of the table I get another -259 error. What gives?
Have you got a commit or rollback work somewhere in the logic? This
closes all cursors, unless you declare them WITH HOLD.
Just a thought.
akent@cix.compulink.co.uk (Andy Kent)
------------------------------------------------
Freelance Informix Database Specialist,
Redland, Bristol, England
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.