Finiding the PF name

70 pts.
Tags:
AS/400 DB2
Comparing Physical File Data
Physical File
Hi Guys,

I am stuck in here to find the physical file name, I know the alternate name of the PF, is there any procedure to find out the original PF name using the alternate name?

Please help



Software/Hardware used:
AS400, DB2400

Answer Wiki

Thanks. We'll let you know when a new response is added.

I suspect you’re thinking the “alternate” name is a logical file? Use the DSPDBR command (display data base relationships)

===================================================

If “alternate name” is a LF, then DSPDBR won’t help.

For a normal LF, use:<pre>
DSPFD mylib/altname TYPE(*ACCPTH)</pre>
…where “altname” is the LF name and “mylib” is the library containing the LF. The name of the PF that is accessed by the LF will be at the end of the displayed information.

However, if “alternate name” refers to a SQL ALIAS, then perhaps use:<pre>
SELECT BASE_TABLE_NAME FROM SYSTABLES WHERE TABLE_NAME = ‘<altname>’</pre>
…where “<altname>” is the ALIAS.

Or perhaps “alternate name” means something else? If so, please describe how the name is used. We can probably figure it out from there.

Tom

Discuss This Question: 1  Reply

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    select system_table_name, table_name from systables Phil
    50,205 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following