how can i know logical file belongs to which physical file
without source?
- 3 Answers
- 20351 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF
What is the difference between access path and open data path?
Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?
How to index LF by relative record no (RRN)
Why we create the Physical File Member?
How to find the list of source physical files in a library?? Is there any way to get a list??
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 ?
I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?
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...
how to restrict upon adding the data for field reference file in DB400
If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.
How can we handle errors in RPG?
RPG400 
