Re: RPG/SQL question.

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
>From the 'SQL Reference' available at
http://publib.boulder.ibm.com/html/as400/v5r1/ic2924/info/db2/rbafzmst02.htm

And then selecting 'isolation clause' at
http://publib.boulder.ibm.com/html/as400/v5r1/ic2924/info/db2/rbafzmstintsel.htm#HDRISOCL

It says to look up 'isolation level' at
http://publib.boulder.ibm.com/html/as400/v5r1/ic2924/info/db2/rbafzmstintsel.htm#HDRISOCL

Partly, it says:
No Commit (NC)
For all operations, the rules of level UR apply except:

Commit and rollback operations have no effect on SQL statements. Cursors
are not closed, and LOCK TABLE locks are not released. However,
connections in the release-pending state are ended.
Any changes are effectively committed at the end of each successful change
operation and can be immediately accessed or changed by other application
groups using different commitment definitions.
DB2 UDB for iSeries supports No Commit through COMMIT(*NONE) or
COMMIT(*NC).

But if you read the entire section on 'isolation level' you'll get more
out of this.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Juan Robledo" <Juan_Robledo@irco.com>
Sent by: rpg400-l-admin@midrange.com
04/29/2002 09:39 AM
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        RPG/SQL question.



Hello all,

Being new to Embedded SQL in RPG ILE, I have a question.

What does 'With NC' do?
I would like to lock the record, Update and it, will this 'With NC' work
or
can i do something else?
Will it commit as soon as the SQL finishes?

                C     csrrrn        Chain     ScnSfl
     C                   If        %found
     C/EXEC SQL
      C+ UPDATE PPA SET PRQSTA = 3, PCHBY = :user, PDTCH =
      C+ :chdate, PTMCH = :chtime WHERE PGRNUM = :GroupNum
     C+ with NC
                                      Endif


Juan Robledo
Programmer Analyst

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.