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 to Define a Procedure in RPG?
is it there an easy way to determine if an html section is available to issue a wrtsection upon?
what are dds required for subfile?
what is message file?
what is the purpose of indicators in rpg?
define the purpose of the leave operation?
using dfu, user will be able to ___________ from physical file?
how can a cgi check whether an ifs object is available?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?
how can you specify no duplicate key?
What is dynslt?
how do you specify the number of records to roll in a subfile ?
How to convert a spool file to PDF file in AS400?
where can you specify an indicator in lokup operation?