Re: CREATE ALIAS ... part II

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

----- Original Message ----- 
From: "G Armour" <garmour400m@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Monday, November 17, 2003 16:53
Subject: SQL: CREATE ALIAS ... part II


> But, how does one determine which member of the PF-DTA file is being
> referenced by ALIAS'd DDM file?  Neither DSPDDMF nor DSPFD shows any
> member references.  The only way I can tell is by opening the ALIAS file
> in SQL and displaying the job with OPTION(*OPNF).
>
> There's gotta be a better way.  ;-)

and there is...

in the catalog table systables, in the schema (library) where the alias is
located, the field BASE_TABLE_MEMBER has the member name for the alias.

the file name is the alias name...


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"If you pick up a starving dog and make him prosperous,
  he will not bite you. This is the principal difference
  between a dog and a man."

    - Mark Twain