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
how many maximum spaces could be given in o specs?
under given circumstances, my cgi should link to another site. How to implement this?
how many files can be defined in f specs?
what is overlay?
What is diff between EVAL & MOVE?
A join logical file has how many record formats?
which are the string manipulation opcodes?
how you get the relative record in a subfile in which cursor is located?
how can I automatically refresh a web page?
where can you specify an indicator in lokup operation?
what is full form for dds?
What is the maximum number of subfiles that can be specified in a display file?
what are necessary keywords to code message subfile?
which indicator is used for read?
what are the various types of device files?