what is primarykey?what is difference between primary key
and forign key?



what is primarykey?what is difference between primary key and forign key?..

Answer / ipsita

Primary key we means a unique and ascending key, which is
the primary, access path for a PF and cannot contain null
values and foreign key the key in the dependent file.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

How many primary files allowed in a program?

1 Answers  


what are different types of substems?

1 Answers   IBM,


Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)

0 Answers   TCS,


what are all the contents of subfile?

1 Answers   IBM,


How to see all record formats used in a file?

1 Answers  






records can be read/update/deleted with which file?

0 Answers   IBM,


What is the purpose of OVRATA keyword ?

1 Answers  


Difference Between Skip Before & Space Before?

0 Answers   IBM,


What is an authorization list?

1 Answers  


4 persons a, b , c , d have to go to concert which will held in 17 minutes. there is a bridge which only 2 persons at a time can cross. its night and they have only one flashlight with them. Flashlight cannot be thrown. one person should return with the flashlight all 4 person have different speed. a = crosses bridge in 1 min. b = crosses bridge in 2 min. c = crosses bridge in 5 min. d = crosses bridge in 10 min how can they all reach in time.?? Ex- suppose a and d crosses bridge which will take 10 mins and then d returns back with a flashlight which will make 20 mins and mission is failed.

1 Answers   Manhattan,


What is left outer join?

2 Answers  


What do you mean by ODP?

1 Answers  


Categories