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
- 11998 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
when would you use or not use this approach?
how to read database records without locking them?
what are the various types of device files?
difference between sflrcdnbr and sflnxtchg?
how to develop some simple graphs (bar charts) using just html?
How to avoid using indicators in ile ?
how do you know that records are locked?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
what are indicators?
can we use ASCII ,CDUP,SENDPASV commands in SFTP?
what is a composite key?
What Is The Difference Between Goto & Exsr?
What is the difference between crtdupobj and copyf?
maximum number of subfiles that can be active for a single file is?
explain the purpose of keep and assume keywords?
