Hi,
Please give the answer to this question?
I have Phisical file with 100 records,there is no any
duplicate records in this pf.Based on this pf one Logical
file i have used.But this lf is viewing only 80 records
only of that pf?What is the reason for this?Please give me
answer?

Answers were Sorted based on User's Feedback



Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any..

Answer / sreedhar reddy

If there is any selection criteria in LF then it may be
displaying accordingly. If there is no "Select" or "Omit"
it should display 100 records. Have a look at LF once again.

Is This Answer Correct ?    30 Yes 0 No

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any..

Answer / murali

I will agree with Sreedhar, adding one more possibility of this scenario as may be object of PF is existing in tow libraries A and B but the object of Logical is existing only in B library and the PF exist in Library B may have only 80 records. But It is true if Library list order is A and B

Is This Answer Correct ?    1 Yes 0 No

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any..

Answer / praveen

Hi
there may be a reason that there exist a blank space in 81 position, which is used by a record and even after the record deletion, if the rgzpfm is not done then after reading 80 records, 81 will be treated as eof; though v have records in later 82 etc

Is This Answer Correct ?    0 Yes 0 No

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any..

Answer / satwika

Out of the hundred records of physical file, only 80 are
present in the member with same name as physical file name and
other 20 in another..

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More DB400 Interview Questions

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,


Why journalling is compulsory before commitment control?

1 Answers  


what is error handling concepts in cl

3 Answers   Active Brains,


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


What is FORMAT keyword and its use?

0 Answers  






How to index LF by relative record no (RRN)

0 Answers  


Can we concatenate fields in physical file? If yes how can we do?

0 Answers  


I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

9 Answers   Mind Tree, TCS,


Why we create the Physical File Member?

5 Answers  


how can we write LF using flatfile.

9 Answers  


Maximum how many fields we can create under a record format of PF?

5 Answers  


When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  


Categories