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

at what level s,o are defined and what they will do?

954


how many printer files maximum can be used in single rpg program?

667


why is as/400 called object oriented machine?

940


how you get the relative record in a subfile in which cursor is located?

607


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

764






what are the various types of device files?

984


what is the maximum number of subroutines allowed in rpg?

1050


how to develop some simple graphs (bar charts) using just html?

662


when is a tag statement used in rpg?

1338


how you will know whether you are in sfldrop or sflfold mode?

621


how can I control from my cgis the cache of a remote browser?

667


how many maximum spaces could be given in o specs?

625


What Is The Error If We Don't Get Login Screen?

671


what is externally described file ?

927


what is a physical file?

989