SQL: CREATE ALIAS ... part II

[G Armour <garmour400m@xxxxxxxxx>]

As discussed in my original post, we are looking at using SQL's ALIAS to
be able to access multi-membered files in SQL.  (The design of using
multi-membered files is out of our hands because it's part of a package we
didn't write.)

So, anyway, I created the ALIAS for Lib/File(MBR), was able to run a
SELECT on the ALIAS, confirmed it was getting the right member, by virtue
of identifying the data it was displaying.

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.  ;-)

TIA, GA


--- G Armour <garmour400m@xxxxxxxxx> wrote:
> Doing a CREATE ALIAS in SQL creates a new object on the system, object
> type *FILE, with an attribute of DDMF.  The file can be deleted,
> renamed,
> moved... it appears to be a normal object in that sense.  However, as a
> data file, the only method of access that I've found is via SQL.  Tried
> RUNQRY, DBU, using it as an input file in an RPG program, DSPPFM, all of
> these failed.  DSPPFM is somewhat telling with the error CPF9162:
>    Cannot establish DDM connection with remote system.
> 
> What remote system?  Cuz it sees the file as DDM?  Why was it created
> with
> that attribute?
> 
> These are mostly academic questions, as the only reason we might use
> ALIAS
> in our situation is to be able to easily work with multi-membered data
> files in SQL.
> 
> TIA, GA
> 
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree