Re: sql with members

[CRPence <CRPbottle@xxxxxxxxx>]

  FWiW the SQL ALIAS is merely _implemented_ as the external *FILE 
object with attribute of DDM.  There is actually no DDM architecture 
[nor DRDA] involved in its use for a /connection/.  The attributes of 
the DDM *FILE object can be retrieved, instead of inquiring of the 
catalog, to redirect the SQL open processing; in other DB2 
implementations there would only be the row in the catalog to track 
if\what existence of an ALIAS just as for INDEX [also implemented as a 
*FILE in DB2 for i].  The existence of a DDMFile as an implementation 
object enables the reclaim of the System Database Cross-Reference [which 
is the basis for the SQL Catalog VIEW objects] to refresh the list of 
SQL ALIAS on the system.

  DDM from z may be available as alternative for access of the data 
directly from the COBOL program however; i.e. just as DDM from i to i 
from a COBOL program on i.

Regards, Chuck

lgoodbar@xxxxxxxxxxxxxx wrote:
> You don't directly. You can, however, create an ALIAS to
> the member. Under the covers, it creates a DDM connection
> to the local database.
>
> File vngdbdta/dbbrrep has two members called wv2006 and
> wv2005 I wish to
> access via SQL.
>
>  create alias vngcusdta/gl_transactions_archive_2005     
>   for vngdbdta/dbbrrep (wv2005)                           
>  Alias GL_TRANSACTIONS_ARCHIVE_2005 created in VNGCUSDTA.
>
>  create alias vngcusdta/gl_transactions_archive_2006     
>   for vngdbdta/dbbrrep (wv2006)                           
>  Alias GL_TRANSACTIONS_ARCHIVE_2006 created in VNGCUSDTA.
>
> Jerry Draper wrote:
>
> > In strsql how do you specify members?
> >
> > ie:  select * from fileA (memberB)