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
- 14171 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 |
how many key fields does cl required
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.
Q.1.What is differences in STRDBG and STRISDB debugging commands? 2.Where we should use STRDBG and STRISDB Debugging commands?
some special characters I key in my html source members show different on my web pages. Why? How can I solve this?
Can be OVRDBF command mentioned after OPNQRYF command in CL?
in which specification the report layout can be defined?
Is it possible to join the same file to itself ?
PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM In above example,what is content of myfile.txt ...Thanx
define the purpose of the *cat function?
Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
what are the different methods to access seu?
CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?
RPG400 
