what is the difference between adding keys & constraints
into a phisical file
- 4 Answers
- 9565 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 can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?
How we can't update join logical files?
I have a pf, it contains 5 members, how to access particular member data from logical file?
how to update physical file using logucal file with example
Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...
How to add a field to a PF and compile it without loss of data?
How to insert more than one record to a pf at a time?(Bulk insert to a pf)
What is FORMAT keyword and its use?
How to change the batch job to interactive job?
There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.
what is multiple member pf
What is the interactive job? What is the batch job? How to change the batch job to interactive job?
RPG400 
