IBM DB400 Question:

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

IBM DB400 Interview Question
IBM DB400 Interview Question

Answer:

if you do a DSPDBR on a
logical file it wont show you the name of the physical file
that it is based on. Rather you need to use DSPFD on the
logical file. DSPDBR on a physical file will show the names
of all the LF files based on that PF.


Previous QuestionNext Question
What is open data path? and what is the diff b/w access path and open data path?How to know the particular record in pf with out reading?