IBM DB400 Question:

Download Job Interview Questions and Answers PDF

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.

Download IBM DB400 Interview Questions And Answers PDF

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?