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?
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
what is the purpose of ovrdta and ovrata keywords ?
what are the different methods to access seu?
what are different record spacing keywords in rlu ?
What is access path in as400?
explain the purpose of keep and assume keywords?
what is sflpag and sflsiz ?
What is the draw back of Procedures? why we are going to Modules?
what opcode could be used to test an alphanumeric field for all numeric values?
define the rcvf command?
How do I remove a flag or check no. or name when a user opens too many sessions?
What Is The Purpose Of The "n" In The Following Calculation Specification?
define a shared access path?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
why is the declare cursor statement is used for?
maximum number of subfiles that can defined in a rpg program for one display file is?