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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

which cl command can be used at program execution to redirect the file named in an rpg program?

1240


what is the use of jdftval in join logical file?

1867


what does the opcode free do?

2020


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

1901


how to get the cursor position?

1189


In RPG How to read a records from a file without using read opcodes?

1563


what is the purpose of data structure?

1801


define data structure?

1828


What Is The Error If We Don't Get Login Screen?

1095


Write a CL program which will run a batch job at 1 am every night

1138


What is RETURN CURSER LOCATION in subfile?

1628


give three main purposes of file specification ?

1811


In 'o' Specs What Is The Opcode For Write?

1263


what is the use of data structures?

1178


what is rpg fixed logic cycle?

1266