RE: sql with members

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.

HTH,
Loyd


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Draper
Sent: Monday, February 02, 2009 3:01 PM
To: Midrange Systems Technical Discussion
Subject: sql with members

In strsql how do you specify members?

ie: select * from fileA (memberB)

Jerry