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 |
what are the limitations of cl (compare to rpg) ?
Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.
What is the use of L specs in RPG?
What are the different types of keywords in display files?
how do we know batch job aborted after we submitting it
how can you check for a records existence without causing and i/o (chain/read)?
what is the clp command to access a query/400?
what keyword must be used with protect keyword ?
what are the different types of variables available in cl?
Why would you prefer OPNQRYF than logical file?
how to define global parameter in ile ?
where can you specify an indicator in lokup operation?