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 |
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.
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...
What is the interactive job?
What is open data path?
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?
one physical file can have how many max of logical files? what is the primary file?
CRTDTA AND CRTARA should be used along with?
What is the interactive job? What is the batch job?
How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?
what is the intractive job? what is the batch job ? how to change the batch job to interactive job?
A pf containing 100 records... my query is how to display from 11th record in the pf?
what is the difference between adding keys & constraints into a phisical file