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 if my system I runs with system value qccsid 65535?

0 Answers   IBM,


Define a Batch Job?

1 Answers  


how will you find a string using pdm?

0 Answers   IBM,


What is the purpose of PR and PI in calling program and called program? in Called program PR is compulsory?

1 Answers   HCL,


what does the opcode free do?

1 Answers   IBM,


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

0 Answers   IBM,


which are the figurative constants used in rpg?

0 Answers   IBM,


What is the type, length of a LDA?

1 Answers  


What is the purpose of RTVMBRD command?

1 Answers  


How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?

2 Answers  


is it possible to do commitment control with out journaling?

1 Answers  


i have recently moved to hyd. i would like to know which is the best institue to learn AS400. are there any in ameerpet? thanks.

4 Answers  


Categories