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

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,


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

0 Answers  


how to add a new field to a file without compiling it?

1 Answers  


what is the difference between adding keys & constraints into a phisical file

6 Answers   HSBC,


how to update physical file using logucal file with example

1 Answers   Wipro,


How many maximum record format a logical file have?

0 Answers  


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  


In how many ways we can create a logical file?`

5 Answers  


what is the purpus of the chain and setll and setgt ?

2 Answers   Four soft,


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

1 Answers   HCL,


How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


how to know total no of records in pf with out using sql??????

3 Answers  


Categories