IBM DB400 Question:
Download Questions PDF

When we create a PF and did not fill up Maint parameter, then by default which access path will the system take & why?

IBM DB400 Interview Question
IBM DB400 Interview Question

Answer:

Access Path Maint parameter use *IMMED.
Access path is updated each time a record is
changed, added, or deleted from a member.

Download IBM DB400 Interview Questions And Answers PDF

Previous QuestionNext Question
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?How to retrieve a physical file after deleting that? What is keyword used for that?