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.
  • philpl1jb
    select system_table_name, table_name from systables Phil
    54,090 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: