Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between adding keys & constraints
into a phisical file
- 4 Answers
- 11695 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kkk
Contraints check the existing data
But keyfields doesnot check the existing data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / praseetha sandeep
when we add keys in a pf it has effect only in that
particular field of pf but when we add constrains to a pf it
has an effect to entire pf
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / megha
1. Keyfileds are with in DB and constraits are added from
addpfcst command externally
2. Using Addpfcst you can maintain the referential integrity
| Is This Answer Correct ? | 2 Yes | 0 No |
How we can't update join logical files?
what is the difference between adding keys & constraints into a phisical file
Can we concatenate fields in physical file? If yes how can we do?
Define interactive jobs and batch jobs
how to restrict upon adding the data for field reference file in DB400
How to add a field to a PF and compile it without loss of data?
CRTDTA AND CRTARA should be used along with?
There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.
I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?
one physical file can have how many max of logical files? what is the primary file?
i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF
Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?
RPG400 
