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
which cl command can be used at program execution to redirect the file named in an rpg program?
what is the use of jdftval in join logical file?
what does the opcode free do?
What Is Default Data Type (if You Define Decimals '0') In Physical File?
how to get the cursor position?
In RPG How to read a records from a file without using read opcodes?
what is the purpose of data structure?
define data structure?
What Is The Error If We Don't Get Login Screen?
Write a CL program which will run a batch job at 1 am every night
What is RETURN CURSER LOCATION in subfile?
give three main purposes of file specification ?
In 'o' Specs What Is The Opcode For Write?
what is the use of data structures?
what is rpg fixed logic cycle?