1. Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther
  2. Suggest New Category

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

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 is the maximum number of elements in an array?

1 Answers  

how to get no of records in file in rpg with out cl cmd

2 Answers   iGate,

the output from my cgi is correctly interpreted by ms internet explorer, whereas netscape navigator would display it as a plain text. What should I do to have also netscape interpreting the html output from my cgi?

0 Answers   IBM,

Which of the following operations does NOT zero the field FLDA defined as 4,0? C MOVE *ZEROS FLDA C Z-ADD *ZEROS FLDA C Z-ADD 0 FLDA C MOVE *ALL'0' FLDA C SUB FLDA FLDA C MOVE '0000' FLDA C CLEAR FLDA C MOVE *BLANKS FLDA

1 Answers  

The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help...

1 Answers  




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

3 Answers  

Diff B/w ref and reffld?

1 Answers  

How I can read and display three fields in the record format DSPFM1 of the display file,while one field(using in one file) is NAME which is Key field in field reference file and another two fields are AGE and ROLL NO are using another file. Please send me coding part.

2 Answers   IBM,

How to create a data queues?

1 Answers  

Feedback about ELI Faridabad.

3 Answers   Eli India,

how can you detect overflow for a print program that prints multiple lines per cycle?

1 Answers   IBM,

What is left outer join?

2 Answers  

For more IBM AS400 AllOther Interview Questions Click Here
Categories