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 maximum number of records you can specify in a display file?
How to reverse a string using RPG?
what are members?
how many levels are there in a physical file?
which are the figurative constants used in rpg?
how to pick up the changed records every time in a subfile after the first change made ?
what is subfile?
what are the basic features of seu?
when would you use or not use this approach?
How do you check object lock
Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out
what does dfu program you to do on a record?
what is the purpose of the indara keyword?
what are the different types of variables available in cl?
which cl command can be used at program execution to redirect the file named in an rpg program?