Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 12626 Views
- I also Faced
- E-Mail Answers
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
In Which Specs Arrays, Tables & Constants Are Defined?
what is join logical file?
How to reverse a string using RPG?
what keyword must be used with protect keyword ?
how to toggle between single line and multi - line display of a particular record in a subfile?
How to add 99 menu (page down) option in menu creation..
define the purpose of the *cat function?
What is the default access path of a file?
Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)
where can you specify an indicator in lokup operation?
what is a spool file?
what is *iso date format?
how can I control from my cgis the cache of a remote browser?
what is logical file?
what is the purpose of putovr (put with explicit override) keyword?
