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 ?    3 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,


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

4 Answers  


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,


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,


what is general and type of general

1 Answers   Active Brains,






How to know logical file belongs to which physical file without source?

1 Answers  


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

2 Answers   Four soft,


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

0 Answers  


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

1 Answers  


Why we create the Physical File Member?

5 Answers  


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

5 Answers  


Is Constent can be define as a key field?

3 Answers  


Categories