Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 to Define a Procedure in RPG?

1663


is it there an easy way to determine if an html section is available to issue a wrtsection upon?

924


what are dds required for subfile?

986


what is message file?

996


what is the purpose of indicators in rpg?

1718


define the purpose of the leave operation?

1527


using dfu, user will be able to ___________ from physical file?

937


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

1038


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?

2533


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

1075


how can you specify no duplicate key?

1102


What is dynslt?

1156


how do you specify the number of records to roll in a subfile ?

2057


How to convert a spool file to PDF file in AS400?

1174


where can you specify an indicator in lokup operation?

1723