What is the difference between access path and open data path?



What is the difference between access path and open data path?..

Answer / Brahmanand Thakur

In DB400, Access Path (APATH) is a method for opening files using a physical file name, while Open Data Path (ODP) is a method that opens files based on their logical file name. APATH is useful when you need to open multiple files with the same structure, and ODP is used when working with sequential files with varying structures.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB400 Interview Questions

Maximum how many fields we can create under a record format of PF?

5 Answers  


Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


how can we write LF using flatfile.

9 Answers  


what is multiple member pf

1 Answers   Active Brains,


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?

1 Answers  


Can we concatenate fields in physical file? If yes how can we do?

1 Answers  


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

1 Answers  


what is error handling concepts in cl

3 Answers   Active Brains,


How to index LF by relative record no (RRN)

1 Answers  


CRTDTA AND CRTARA should be used along with?

2 Answers  


What is the purpose of the chain and setll and setgt?

1 Answers  


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