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

what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,


Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers  


what is the purpus of the chain and setll and setgt ?

2 Answers   Four soft,


How to index LF by relative record no (RRN)

0 Answers  






what is general and type of general

1 Answers   Active Brains,


What is the batch job?

0 Answers  


pls anyone explain about compile time array,pre run time array run time array

4 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,


How to know the particular record in pf with out reading?

0 Answers  


how to restrict upon adding the data for field reference file in DB400

1 Answers  


how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,


Categories