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

maximum number of subfiles that can be active for a single file is?

1353


what is the command used to invoke rlu ?

1545


how many files, printer files you can describe in a rpg?

870


how to toggle between single line and multi - line display of a particular record in a subfile?

1457


what is a query can be run in which mode?

1085


what is the maximum number of subroutines allowed in rpg?

1426


is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

813


What is diff between EVAL & MOVE?

1243


define the rcvf command?

1355


What is file information data structure(infds) in as400?

1237


Space & Skip Are Which Level Keywords?

979


what if my system I runs with system value qccsid 65535?

847


Can level check error occur if we do chgpf?

1021


What Does Lokup Does In Tables & Arrays?

990


how you will know whether you are in sfldrop or sflfold mode?

857