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 / kishore
at the time of compiling program take f4 & set commit option *NONE
or in program place
c/exec sql
c/+ set option commit = *none
c/end-ecxec
after write statement like
c/exec sql
c/+ update table name set empname = 'value'
c/end-ecxe
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
what is message file?
how to get the cursor position?
What is diff between EVAL & MOVE?
what is sflinz and sflrna?
WHAT IS FERERENTIAL INTRIGRITY ?
what is the maximum number of subfiles that can specified in a display file ?
how can a cgi check whether an ifs object is available?
which of the following operations does not zero the field flda defined as 4,0?
what are necessary keywords to code message subfile?
what would be the effect on the field where reverse image, underline and highlight display attributes were active?
what is externally described file ?
how do you use commitment control in rpg program ?
what is a spool file?
define the purpose of the iter operation?
Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?