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...

  1. Categories >> Software >> MainFrame >> IBM AS400 >> DB400
  2. Suggest New Category

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

Question Posted / praseetha sandeep

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

How we can't update join logical files?

10 Answers  

one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

how to update physical file using logucal file with example

1 Answers   Wipro,

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

1 Answers  

how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  

How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers  

What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  

How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,

how can we write LF using flatfile.

9 Answers  

what is error handling concepts in cl

3 Answers   Active Brains,

Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  

For more DB400 Interview Questions Click Here
Categories