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?
Answers were Sorted based on User's Feedback
Answer / syam
You cannot update Physical file or Logical File.
duplicate key
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / rajesh
While updating the Physical file, it looks for constraints
on all the all logicals defined over it.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / 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 |
Answer / ankur
no u can not give duplicate value while updating through
physical file. Because logical file based on physical file
and having accesspath that is base on physical file
accesspath.
| Is This Answer Correct ? | 1 Yes | 1 No |
list some of the commonly used commands for debugging?
maximum number of subfiles that can defined in a rpg program for one display file is?
Q. 1.What would be structure of CL PGM. 2. What are the levels of CL PGM. 3.How many files can be defined in new CLLE program?
how can I give more performance to some selected pages?
How to see active jobs of the system.
can error messages as a result of a comp, range or values keyword be overridden?
WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?
What is the use of E specification in RPG?
how do you turn off indicators 50 through 59 in only one operation
what would be the effect on the field where reverse image, underline and highlight display attributes were active?
how can we view the entire objects and its types in a pgm?
what are different record spacing keywords in rlu ?