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
- 12498 Views
- I also Faced
- E-Mail Answers
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
how to pick up the changed records every time in a subfile after the first change made ?
how to toggle between single line and multi - line display of a particular record in a subfile?
what is the function of rlu ?
what does the opcode free do?
What is program status data structure(psds) in as400?
in conjunction with which statements can orxx and andxx conditions be used ?
what is a program described file in rpg?
Can level check error occur if we do chgpf?
1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?
what is the maximum number of files allowed in rpg?
how to get the cursor position?
what is the difference between *like and *namvar ?
in conjunction with what other keyword must ovrdta and ovrata be used?
how can database records be read without lock ?
how you will know whether you are in sfldrop or sflfold mode?
