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


How to change the batch job to interactive job?

0 Answers  


Last statement of any RPG pgm is LR?

5 Answers  


can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,


how to eliminate the level check error

2 Answers   TCS,






How we can't update join logical files?

10 Answers  


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

3 Answers   Accenture, Cognizant, eFunds,


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

1 Answers   HCL,


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

2 Answers   Active Brains, UHG,


How to know logical file belongs to which physical file without source?

1 Answers  


Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,


Categories