I have SQLRPGLE program in which there are some update
statements which executed correctly. there were no errors run
time. Once the program gets over, the file was not updated
with the new values. What might be the reason?

Answer Posted / shashank jain

In your code write
c/exec sql
c/+ set isolation level = NC
c/end-exec
before your update statement

Or
try this as your update statement both will work
c/exec sql
c/+ update table name set empname = 'value' with NC
c/end-exec

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are members?

610


how to write code for singlepage in sqlrpgle with update ?

2367


What is data structure in as400? What is the use of data structure?

604


What is the Difference between command attention key and command function key ?

793


during input operation which indicator position is seton if there is a record lock?

930






which are control break logic indicators?

639


What is dynslt?

788


if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1006


what does vldcmdkey means?

819


What Does 'sr' In Columns 7-8 Of C Specs Mean?

1069


what is the difference between sflclr and sflinz?

1038


What Is The Difference Between Goto & Exsr?

1175


what does check opcode do ?

1069


what is the syntax for plist?

651


what is procedure prototype and procedure interface.

621