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 |
can I copy content of Physican file in some source Member of type TXT? Thanx..
What is the Select and Omit criteria in logical file?
why is the declare cursor statement is used for?
How can we read file using curser? how to define a curser?
Specify different indicators used in RPG?
what are different record spacing keywords in rlu ?
What is the benefit of using Externally Described files over Internally Described?
how many key fields does cl required
What would be the output of the variable result? D RESULT S 5S O INZ(00011) C EVAL RESULT = %TRIM(RESULT) Please give me the correct answer for this A.0001 b.compile time error c.11 d.Runtime error
Why would you prefer OPNQRYF than logical file?
What is the difference between crtdupobj and copyf?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE