Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 14387 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is the difference between externally described file and program described file?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
can you have multiple key lists for a single file ?
can error messages as a result of a comp, range or values keyword be overridden?
Is qgpl a user library or system library?
what are the different opcodes available in rpg for database access ?
where exactly we can use OPNQRYF ?
maximum number of subfiles that can defined in a rpg program for one display file is?
how to insert the data in pf by using cl program
Is it possible to add an keyfield or field to an Physical file without changing its file identifier. Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.
how to define global parameter in ile ?
i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?
RPG400 
