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

How can we handle errors in RPG?

4 Answers  


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

2 Answers   Four soft,


Why we create the Physical File Member?

5 Answers  


How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 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  






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

4 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 difference between adding keys & constraints into a phisical file

6 Answers   HSBC,


how to update physical file using logucal file with example

1 Answers   Wipro,


what is error handling concepts in cl

3 Answers   Active Brains,


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

5 Answers   Infosys,


How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  


Categories