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
How to avoid using indicators in ile ?
what is the maximum number of fields under a record format of physical file?
what is the maximum number of files allowed in rpg?
what is a join logical file?
what is join logical file?
under given circumstances, my cgi should link to another site. How to implement this?
which indicator is used for read?
Can we debug the MSGW JOBS?
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
what is the use of jdftval in join logical file?
where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?
how do you specify the number of records to roll in a subfile ?
why is as/400 called object oriented machine?
what are various techniques to pass parameters from one program to another?
when should I use method get, and when should I use method post in my cgis?