how can i know logical file belongs to which physical file
without source?
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 with out any data but the dependent LF is having data?
can we concate fileds in physical file? If yes how can we do?
how to add a new field to a file without compiling it?
What is the use of member in pf?
How many maximum record format a logical file have?
How to find the list of source physical files in a library?
I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?
There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.
how to update physical files using normal logical file
How to know the perticular record in pf with out reading?
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
How to index LF by relative record no (RRN)