Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how can i know logical file belongs to which physical file
without source?

Answers were Sorted based on User's Feedback



how can i know logical file belongs to which physical file without source?..

Answer / vinay pawar

No Its not the correct 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.

Is This Answer Correct ?    45 Yes 0 No

how can i know logical file belongs to which physical file without source?..

Answer / tim austin

if you enter dspfd tgi3500l1
you will get a display part of which is seen below which
will tell the name and location of the physical file. But
if you use smart naming convention as seen here you wouldnt
need any command because our shop ends all physical files
with pf and all logicals with l1 l2 l3 etc thereby
providing he answer in the file name

Files accessed by logical file PFILE
File Library LF Format
TGI3500PF CJTPRODDAT TGI3500L1

Is This Answer Correct ?    3 Yes 0 No

how can i know logical file belongs to which physical file without source?..

Answer / chinnu

Using DSPFD

Is This Answer Correct ?    0 Yes 0 No

how can i know logical file belongs to which physical file without source?..

Answer / afnas

use DSPDBR command

Is This Answer Correct ?    14 Yes 31 No

Post New Answer

More DB400 Interview Questions

what is general and type of general

1 Answers   Active Brains,


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


How many max. Record format a logical file have?

13 Answers   Systime,


how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  


What is FORMAT keyword and its use?

0 Answers  


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

3 Answers   Accenture, Cognizant, eFunds,


pls anyone explain about compile time array,pre run time array run time array

4 Answers  


Last statement of any RPG pgm is LR?

5 Answers  


how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,


wirte a simple program for read file in cl

2 Answers   Active Brains,


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

1 Answers   TCS,


Categories