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

what is the purpose of ovrdta and ovrata keywords ?

1185


what are the different methods to access seu?

847


what are different record spacing keywords in rlu ?

1583


What is access path in as400?

1138


explain the purpose of keep and assume keywords?

1433


what is sflpag and sflsiz ?

2872


What is the draw back of Procedures? why we are going to Modules?

1488


what opcode could be used to test an alphanumeric field for all numeric values?

1458


define the rcvf command?

1352


How do I remove a flag or check no. or name when a user opens too many sessions?

2012


What Is The Purpose Of The "n" In The Following Calculation Specification?

907


define a shared access path?

1327


I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

2518


why is the declare cursor statement is used for?

840


maximum number of subfiles that can defined in a rpg program for one display file is?

1565