Re: RPG/SQL question.

NC = No commitment control

Update are updates.... etc ....

>>> Juan_Robledo@irco.com 04/29/02 07:39AM >>>

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.