Re: Commit in DB2/MVS

[Randy Learn <rlearn@UAKRON.EDU>]

Thank you for the reply's on the DB2 commit issue. I was out of the office a
few days, hence my slow reply.

Unfortunately I can not post the code since the program  is quite large.  But
the general flow of the program is this:

1. I read a sequential file
2. The program does a few selects to find key values.
3. The program inserts records into approximately 20 tables and updates 3
tables.
4. After x number of records are processed from the sequential file a commit
is issued.

The commit is not in a select loop and any where clause on the selects are
using $string variables.  I put a begin-sql, end-sql around the commit with an
on-error statement to see if I could capture more detail information on the
abend.  After processing x number of records and issuing a commit the error
indicated that the select after the commit was no longer prepared.  Knowing
that begin-sql, end-sql around the commit is incorrect I remove them.  Don't
know if this info helps any?  Again the commit did actually commit the
records.

I have never used the 'With Hold' option in SQR, since it automatically
handles the cursors for you.  How would you specify the 'with hold' option in
SQR?

Randy