i have one physical file which is having two logical files.
logical a have unique keyword and logical b doesnt have a
unique keyword. can i give duplicate values while updating
through physical file. if no why?
Answer Posted / sumit gupta
Whenever you update physical file, then it checks for all
file level keyword that specifies on logical file if any.
If no logical then simple update will perform.
In this, before updating your physical file temporary
program will get the UNIQUE specified as file level keyword
on 1 logical file.
And thus it through error, Duplicate key error in another
database member
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the purpose of indicators in rpg?
what is the purpose of the indara keyword?
How to reverse a string using RPG?
how to validate input values in display file ?
What are the record format field mapping options in cpyf?
How to avoid using indicators in ile ?
describe the difference between the dowxx and douxx operations?
how do you use commitment control in rpg program ?
what does defn do?
what are the various types of device files?
To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?
what are different types of substems?
Using %check we are checking monika in mona what is output? What is %SCAN?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
What is the use of jdftval in as400?