Re: sql with members

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)