Re: SQL Select question

[MWalter@xxxxxxxxxxxxxxx]

You have to either do an OVRDBF before you call the program with the
select. Or CREATE ALIAS. SQL has no knowledge of multiple member files.
CREATE ALIAS is something that I believe is specific to the iSeries.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                           
             Rich_Weislak@mhsn                                             
             r.org                                                         
             Sent by:                                                   To 
             midrange-l-bounce         midrange-l@xxxxxxxxxxxx             
             s+mwalter=hanover                                          cc 
             wire.com@midrange                                             
             .com                                                  Subject 
                                       SQL Select question                 
                                                                           
             07/11/2005 11:46                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




All, I have a database on the 400 that has difference members within that
database, in the Select statement how can I reference just that member???

Rich



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