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?
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 |
4 persons a, b , c , d have to go to concert which will held in 17 minutes. there is a bridge which only 2 persons at a time can cross. its night and they have only one flashlight with them. Flashlight cannot be thrown. one person should return with the flashlight all 4 person have different speed. a = crosses bridge in 1 min. b = crosses bridge in 2 min. c = crosses bridge in 5 min. d = crosses bridge in 10 min how can they all reach in time.?? Ex- suppose a and d crosses bridge which will take 10 mins and then d returns back with a flashlight which will make 20 mins and mission is failed.
how do you turn off indicators 50 through 59 in only one operation
can u plz tell me is there any difference between SHELL SCRIPT & SFTP SCRIPT? I want to run LS & GET(automatically) command from CL program....which script can be used?
What Is Ddm ?
Logic cycle
WHAT IS DECIMAL DATA ERROR IN RPG IV...WHEN WILL IT HAPPENS?
What is the symbol used for copying & moving new field in SDA?
What Is Default Data Type (if You Define Decimals '0') In Physical File?
What are the different ways to input data into data area?
what is externally described file ?
what is pointer error in rpg IV?
Describe about Query/400?