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 |
What is the purpose of the chain and setll and setgt?
How to read a PF in reverse(from last rec to first) using CL?
How to read a pf in reverse(from last record to first) using cl?
What is FORMAT keyword and its use?
What is the primary file?
In how many ways we can create a logical file?`
how to know total no of records in pf with out using sql??????
what is exception and how many types of exception
What is the difference between access path and open data path?
How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?
what is the intractive job? what is the batch job ? how to change the batch job to interactive job?
Last statement of any rpg program is lr?