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?

Answers were Sorted based on User's Feedback



I have SQLRPGLE program in which there are some update statements which executed correctly. there ..

Answer / 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

I have SQLRPGLE program in which there are some update statements which executed correctly. there ..

Answer / shashank jain

In your code write
c/exec sql
c/+ set isolation level = NC
c/end-exec
before your update statement

Or
try this as your update statement both will work
c/exec sql
c/+ update table name set empname = 'value' with NC
c/end-exec

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

What is library is as400? What are the types of library?

1 Answers  


WHAT IS DECIMAL DATA ERROR IN RPG IV...WHEN WILL IT HAPPENS?

6 Answers   CTS,


what is externally described file ?

1 Answers   IBM,


what is the length of a variable in rpg?

1 Answers   IBM,


What are all the different types of access path?

1 Answers  


How to know message id (errorid) in msgfile when error is occurred on screen ? WRKMSF will display all error id but i want to know error id based on error msg only?

1 Answers   IBM, Ignis Technologies, SSR,


What is Job, What are the attributes of a Job?

1 Answers  


how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE

3 Answers   iGate,


what is a join logical file?

0 Answers   IBM,


http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?

0 Answers   IBM,


what does check opcode is used?

1 Answers   IBM,


Is it possible to add an keyfield or field to an Physical file without changing its file identifier. Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.

2 Answers  


Categories