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


Please Help Members By Posting Answers For Below Questions

what is message file?

808


how to get the cursor position?

924


What is diff between EVAL & MOVE?

1218


what is sflinz and sflrna?

1266


WHAT IS FERERENTIAL INTRIGRITY ?

1386


what is the maximum number of subfiles that can specified in a display file ?

1392


how can a cgi check whether an ifs object is available?

845


which of the following operations does not zero the field flda defined as 4,0?

937


what are necessary keywords to code message subfile?

1353


what would be the effect on the field where reverse image, underline and highlight display attributes were active?

1235


what is externally described file ?

1296


how do you use commitment control in rpg program ?

1646


what is a spool file?

903


define the purpose of the iter operation?

1405


Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?

898