Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 12589 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
distinguish between terminating a program through seton lr and return?
why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell
What is difference between fully procedural file and primary file?
What is SDA used for?
Difference Between Call & Sbmjob?
Q.How can more than two program be executed in batch mode through SBMJOB in CL PGM but the condition is that program must be executed one by one?Please wtite the senario? 2. IS it possibe more then two programs can be executed in batch mode and HOw it will be executed in CL program ,please write the senario?
Can an indexed file be accessed in arrival seQuence in RPG program ?
which cl command is used to trap error messages during program execution?
what is the purpose of the indara keyword?
what is the favicon.ico request that my site receives now and then?
what are the different types of keys in AS400
what is logical file?
RPG400 
