what is the difference between adding keys & constraints
into a phisical file
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 to retrieve a physical file after deleting that?
what is exception and how many types of exception
YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?
Which keyword is used both in subfile and subfile control record format of a DSPF?
Define interactive jobs and batch jobs
A pf containing 100 records... my query is how to display from 11th record in the pf?
how to eliminate the level check error
Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?
When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?
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
What is the batch job?
what is multiple member pf