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 / 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 |
Post New Answer View All Answers
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
can a join logical file be updated?
What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?
what is subfile?
what is the purpose of ovrdta (override data) keyword?
where can you specify an indicator in lokup operation?
give three main purposes of file specification ?
define the purpose of the *bcat function?
difference between view and index ?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
How do you check object lock
How to reverse a string using RPG?
In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.
what is sflinz and sflrna?
define subsystem?