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

how many maximum spaces could be given in o specs?

627


under given circumstances, my cgi should link to another site. How to implement this?

570


how many files can be defined in f specs?

1372


what is overlay?

670


What is diff between EVAL & MOVE?

968






A join logical file has how many record formats?

593


which are the string manipulation opcodes?

617


how you get the relative record in a subfile in which cursor is located?

609


how can I automatically refresh a web page?

628


where can you specify an indicator in lokup operation?

1133


what is full form for dds?

732


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

1137


what are necessary keywords to code message subfile?

1004


which indicator is used for read?

619


what are the various types of device files?

986