IBM DB400 Question:
Download Questions PDF

I have Physical 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?

IBM DB400 Interview Question
IBM DB400 Interview Question

Answer:

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.

Download IBM DB400 Interview Questions And Answers PDF

Previous QuestionNext Question
How to know the particular record in pf with out reading?When we create a PF and did not fill up Maint parameter, then by default which access path will the system take & why?