what is the difference between adding keys & constraints
into a phisical file

Answers were Sorted based on User's Feedback



what is the difference between adding keys & constraints into a phisical file..

Answer / cyjil

CONSTRAINTS ARE ADDED EXTERNALLY .... BUT KEYS ARE ADDED
INTERNALLY..

Is This Answer Correct ?    6 Yes 1 No

what is the difference between adding keys & constraints into a phisical file..

Answer / kkk

Contraints check the existing data
But keyfields doesnot check the existing data.

Is This Answer Correct ?    4 Yes 0 No

what is the difference between adding keys & constraints into a phisical file..

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

what is the difference between adding keys & constraints into a phisical file..

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

Post New Answer

More DB400 Interview Questions

Last statement of any rpg program is lr?

0 Answers  


how to add a new field to a file without compiling it?

1 Answers  


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?

0 Answers  


can any one tell me what is meant by PSSR? Kindly elaborate it...

1 Answers  


How to retrieve a physical file after deleting that?

0 Answers  






What is the purpose of the chain and setll and setgt?

0 Answers  


wirte a simple program for read file in cl

2 Answers   Active Brains,


Is Constent can be define as a key field?

3 Answers  


Why journalling is compulsory before commitment control?

1 Answers  


what is use of self join and which cases you will use this join

1 Answers   TCS,


Define interactive jobs and batch jobs

6 Answers  


In how many ways we can create a logical file?`

5 Answers  


Categories