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
at what level s,o are defined and what they will do?
how many printer files maximum can be used in single rpg program?
why is as/400 called object oriented machine?
how you get the relative record in a subfile in which cursor is located?
What is the Difference between command attention key and command function key ?
what are the various types of device files?
what is the maximum number of subroutines allowed in rpg?
how to develop some simple graphs (bar charts) using just html?
when is a tag statement used in rpg?
how you will know whether you are in sfldrop or sflfold mode?
how can I control from my cgis the cache of a remote browser?
how many maximum spaces could be given in o specs?
What Is The Error If We Don't Get Login Screen?
what is externally described file ?
what is a physical file?