Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

0 Answers  


How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


What is FORMAT keyword and its use?

0 Answers  


What is the primary file?

0 Answers  


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

5 Answers  


how to know total no of records in pf with out using sql??????

3 Answers  


what is exception and how many types of exception

1 Answers   Active Brains,


What is the difference between access path and open data path?

0 Answers  


How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  


what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,


Last statement of any rpg program is lr?

0 Answers  


Categories