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
what are members?
how to write code for singlepage in sqlrpgle with update ?
What is data structure in as400? What is the use of data structure?
What is the Difference between command attention key and command function key ?
during input operation which indicator position is seton if there is a record lock?
which are control break logic indicators?
What is dynslt?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
what does vldcmdkey means?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
what is the difference between sflclr and sflinz?
What Is The Difference Between Goto & Exsr?
what does check opcode do ?
what is the syntax for plist?
what is procedure prototype and procedure interface.