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
11969 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

Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?

0 Answers

What is the purpose of OVRDTA keyword ?

1 Answers

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

6 Answers CTS,

in which specification the report layout can be defined?

1 Answers IBM,

what does check opcode do ?

1 Answers IBM,

what is the command to know key fields of file?

0 Answers IBM,

different type of cursor?