AS/400 Physical file

450 pts.
Tags:
AS 400
How to find the physical file associated with a logical file?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Run DSPFD for the LF. Under the 'Access Path Description' section, see the 'Files accessed by logical file' (PFILE) attribute. Any referenced PFs should be listed there.

    If the LF is a SQL VIEW or INDEX, any TABLE (or PF) should also show in the 'Data Base File Attributes' section. The 'SQL view create statement' or 'SQL Index create statement' attribute should show either the based-on TABLE (or PF) or show the VIEW (or LF) that needs to be looked at next.
    36,035 pointsBadges:
    report
  • vivekntt21
    Thank you for your answer and it really helped for me.
    450 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: