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 if my system I runs with system value qccsid 65535?
Define a Batch Job?
how will you find a string using pdm?
What is the purpose of PR and PI in calling program and called program? in Called program PR is compulsory?
what does the opcode free do?
is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?
which are the figurative constants used in rpg?
What is the type, length of a LDA?
What is the purpose of RTVMBRD command?
How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?
is it possible to do commitment control with out journaling?
i have recently moved to hyd. i would like to know which is the best institue to learn AS400. are there any in ameerpet? thanks.