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 is library is as400? What are the types of library?
WHAT IS DECIMAL DATA ERROR IN RPG IV...WHEN WILL IT HAPPENS?
what is externally described file ?
what is the length of a variable in rpg?
What are all the different types of access path?
How to know message id (errorid) in msgfile when error is occurred on screen ? WRKMSF will display all error id but i want to know error id based on error msg only?
1 Answers IBM, Ignis Technologies, SSR,
What is Job, What are the attributes of a Job?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE
what is a join logical file?
http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?
what does check opcode is used?
Is it possible to add an keyfield or field to an Physical file without changing its file identifier. Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.