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
maximum number of subfiles that can be active for a single file is?
what is the command used to invoke rlu ?
how many files, printer files you can describe in a rpg?
how to toggle between single line and multi - line display of a particular record in a subfile?
what is a query can be run in which mode?
what is the maximum number of subroutines allowed in rpg?
is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?
What is diff between EVAL & MOVE?
define the rcvf command?
What is file information data structure(infds) in as400?
Space & Skip Are Which Level Keywords?
what if my system I runs with system value qccsid 65535?
Can level check error occur if we do chgpf?
What Does Lokup Does In Tables & Arrays?
how you will know whether you are in sfldrop or sflfold mode?