Re: Commit in DB2/MVS

["McCoy, Ken D (INPO)" <McCoyKD@INPO.ORG>]

A commit in DB2 will automatically close your open cursor
so when you do another fetch of the cursor it will blow up

HTH


 Ken

> -----Original Message-----
> From: Randy Learn [SMTP:rlearn@UAKRON.EDU]
> Sent: Thursday, October 01, 1998 3:48 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Commit in DB2/MVS
>
> Any help would be greatly appreciated.
>
> I am using DB2 version 4 and SQR version 4 on windows NT and MVS
> mainframe.
> I have an sqr program that issues a commit after x number of records
> are
> processed.
> When I run it on the NT/Client it runs ok, when I run it on the MVS
> server it abends after the commit is executed.  The commit is actually
> working, but it seems to blow up on a select after the commit.   The
> program runs ok on MVS with the 'commit' commented out.  This is a
> conversion program that will load a large volume of data and needs to
> do
> a commit periodically.
>
> Has anyone else run into this???
>
>
> DSN      ENDED DUE TO ERROR+
>  SYSTEM ABEND CODE 04E   REASON CODE 00E7000C  PSW 077C100087713180
> ASIDS:  HOME
> 1LSCX041 **** ERROR ****
>          ABEND occurred in line  1020 of    SQ043(SQ048)  ,offset
> 000390
>
>          Program terminated by operating system. ABEND code = S04E
>          A non-C or system routine was running at the time of ABEND