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
what is the purpose of ovrdta (override data) keyword?
what is the function of rlu ?
what is arrival sequence?
which of the cl command can be used to determine which logical files are dependent on a specific file?
what is sflrolval?
what is join logical file?
what is the command to know key fields of file?
how can I control from my cgis the cache of a remote browser?
what is subfile?
how to get the cursor position?
an access path may be in which sequence?
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 are the different types of arrays available in rpg ?
how many files can be defined in f specs?
What Is The Error If We Don't Get Login Screen?