I have SQLRPGLE program in which there are some update statements which execut

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?

Question Posted / praveenas400

2 Answers
12629 Views
I also Faced
E-Mail Answers

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

can a indexed file be accessed in arrival sequence in rpg program?

1 Answers IBM,

268 How many parameters can be defined in a RPG program. ?

1 Answers

Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?

3 Answers

define the purpose of the iter operation?