Re: Pro*C cursor problem

I got this two, but i got it after i was doing commit and then continure fetching the cursor. The cursor was build dynamic and was on table in DB2 MVS V4.1 . I found that if i put commit adter the open and before the first fetch, i can do commit in the loop and the cursor won't be closed at commit.

Uri

On Mon, 16 Nov 1998 15:10:02 -0600, Jon Clendenen <jonmc2_at_nortel.com> wrote:

>I have a problem with a Pro*C application that I have upgraded from
>version 1 to version 2. The code has three nested cursors that are used
>to build a set of files for input to a different system. This code has
>worked for over a year on the old system, and has been migrated
>successfully in its compiled form to a new system. I have had to make a
>change in formatting of a date field to YYYY instead of YY, and need to
>recompile on the new system. I got a 'Fetch out of Sequence' error.
>
>The old code compiled on the old system will run on the new system
>properly, but when the same code is compiled successfully on the new
>system I get a 'Fetch Out of Sequence' error on the first cursor. Any
>ideas what is the problem here? I'm stumped.
>
Received on Tue Nov 17 1998 - 22:45:03 CET