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 Object Type Of Pf, Lf, Printer File & Display File?
what does defn do?
How can we read file using curser? how to define a curser?
what does check opcode do ?
define what a data area is along with a brief example of what it may be used for?
which are the member types which seu supports?
what is a spool file?
What is %CHECK?
how can you check for a records existence without causing and i/o (chain/read)?
What is compiler directive in as400? Give example of compiler directive.?
what is scan and xlate?
Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
explain the difference between defining subfile and message-subfile?
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.
1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?