Oppolzer - Informatik / Blog

R.S. wrote:

Is it an Online program running under CICS? Has there been a CICS SYNCPOINT
issued before the CLOSE? CICS SYNCPOINT triggers a DB2 COMMIT.

----- Original Message -----
From: "Bernd Oppolzer" <Bernd.Oppolzer@T-ONLINE.DE>
Newsgroups: bit.listserv.db2-l
To: <DB2-L@LISTSERV.YLASSOC.COM>
Sent: Saturday, May 24, 2003 9:42 AM
Subject: Re: Will "INSERT" Close a Cursor?

> Hello,
>
> INSERT does not close a cursor. If the cursor has really been closed, there
> must be another reason.
>
> Regards
>
> Bernd
>
> Am Fre, 23 Mai 2003 schrieben Sie:
> > Hi All ,
> >
> > We have a COBOL application program that:
> > 1.) opens a cursor and fetches from it
> > 2.) inserts to a DB2 table
> > 3.) attempts to close the cursor and receives a -501 sqlcode on the
> > close
> >
> > Since no commit was executed, can I assume that the "insert" caused an
> > automatic close of the cursor and therefore the subsequent -501 ?
> >
> > Thanks,
> > J.