Re: Commit in DB2/MVS

["Schaetzly, Kent" <X2SCHAET@SOUTHERNCO.COM>]

Try the 'with hold' option of declare cursor.  DECLARE cursor-name CURSOR
WITH HOLD FOR select ...  I believe that DB2 will retain cursor positions
across comit points when you specify this.

Kent Schaetzly
The Millennium Project
phone:  506-5170

> -----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