RE: SQL on multiple member PF?

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

OVRDBF command to override to the specific member name before you run the
SQL

-----Original Message-----
From: Tom [mailto:tomh@xxxxxxxxx] 
Sent: Thursday, May 15, 2003 2:51 PM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL on multiple member PF?



I have a physical file with 20 members, and I need to run SQL on a specific 
member within that PF.  I normally use my select statement like so:

select * from mylib/myfile

In this case, the SQL statements is performed on the first member in the 
file.  How do I specify which member to use?


_______________________________________________
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.