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

Answers were Sorted based on User's Feedback



When u create a PF and did not fill up Maint parameter, then by default which access path will the ..

Answer / syam

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

Is This Answer Correct ?    25 Yes 0 No

When u create a PF and did not fill up Maint parameter, then by default which access path will the ..

Answer / prabhas

Default access path is based on key if it is keyed PF, If
the PF is not keyed then default access path is Arrival

Is This Answer Correct ?    4 Yes 12 No

Post New Answer

More DB400 Interview Questions

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

5 Answers   Infosys,


How to update physical file using logical file with example?

0 Answers  


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,


Why we create the Physical File Member?

5 Answers  


what is use of self join and which cases you will use this join

1 Answers   TCS,


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?

0 Answers  


How to index LF by relative record no (RRN)

0 Answers  


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


How to find the list of source physical files in a library?

0 Answers  


can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,


Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  


how can we write LF using flatfile.

9 Answers  


Categories