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 are the limitations of cl (compare to rpg) ?

1 Answers   IBM,


Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.

3 Answers  


What is the use of L specs in RPG?

1 Answers  


What are the different types of keywords in display files?

1 Answers  


how do we know batch job aborted after we submitting it

1 Answers  






how can you check for a records existence without causing and i/o (chain/read)?

1 Answers   IBM,


what is the clp command to access a query/400?

1 Answers   IBM,


what keyword must be used with protect keyword ?

1 Answers   IBM,


what are the different types of variables available in cl?

1 Answers   IBM,


Why would you prefer OPNQRYF than logical file?

1 Answers  


how to define global parameter in ile ?

0 Answers   IBM,


where can you specify an indicator in lokup operation?

1 Answers   IBM,


Categories