RE: SQL Select from a record

Or use SQL to CREATE an ALIAS that points to that member.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/21/2003 12:55 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: SQL Select from a record






Override the file to the correct member prior to executing the SQL 
statement.


> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Wills, Mike N. (TC)
> Sent: Friday, November 21, 2003 10:30 AM
> To: RPG Mailing List
> Subject: SQL Select from a record
> 
> 
> I am accessing a file with multiple members. I need to be 
> able to use SQL to
> get at a record other than the default record. How do I do 
> this in SQL?
> 
> Mike Wills
> Lawson Programmer/Administrator
> Taylor Development
> Email: mnwills@xxxxxxxxxxxxxx
> Direct Line: (507) 625-3187
> 
> CONFIDENTIAL INFORMATION
> 
> NOT TO BE COPIED WITHOUT AUTHORIZATION
> 
> The information contained in this electronic mail 
> transmission may contain
> privileged communications and/or confidential information 
> intended only for
> the use of the named recipient(s).  If the reader of this 
> information is not
> the named recipient(s) or you receive this transmission in 
> error, please:
> (1) immediately notify us by return electronic  transmission at
> mnwills@xxxxxxxxxxxxxx; and (2) permanently delete this 
> message from your
> computer and all servers and other stored devices.
> 

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.