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

4 persons a, b , c , d have to go to concert which will held in 17 minutes. there is a bridge which only 2 persons at a time can cross. its night and they have only one flashlight with them. Flashlight cannot be thrown. one person should return with the flashlight all 4 person have different speed. a = crosses bridge in 1 min. b = crosses bridge in 2 min. c = crosses bridge in 5 min. d = crosses bridge in 10 min how can they all reach in time.?? Ex- suppose a and d crosses bridge which will take 10 mins and then d returns back with a flashlight which will make 20 mins and mission is failed.

1 Answers   Manhattan,


how do you turn off indicators 50 through 59 in only one operation

1 Answers  


can u plz tell me is there any difference between SHELL SCRIPT & SFTP SCRIPT? I want to run LS & GET(automatically) command from CL program....which script can be used?

1 Answers  


What Is Ddm ?

1 Answers  


Logic cycle

1 Answers  


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

6 Answers   CTS,


What is the symbol used for copying & moving new field in SDA?

1 Answers  


What Is Default Data Type (if You Define Decimals '0') In Physical File?

1 Answers   IBM,


What are the different ways to input data into data area?

1 Answers  


what is externally described file ?

1 Answers   IBM,


what is pointer error in rpg IV?

4 Answers   CTS,


Describe about Query/400?

1 Answers  


Categories