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

what is general and type of general

1 Answers   Active Brains,

In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,

What is open data path?

0 Answers  

how to update physical file using logucal file with example

1 Answers   Wipro,

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

5 Answers   Infosys,

CRTDTA AND CRTARA should be used along with?

2 Answers  

What is the interactive job? What is the batch job?

0 Answers  

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,

I had created one physical file tell me command to enter data in to?

1 Answers  

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

0 Answers  

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers  

What is the use of member in pf?

0 Answers  

For more DB400 Interview Questions Click Here
Categories