RE: SQL Select from a record

Rob,

I've never tried that.  I'll have to check it out the next time I deal with 
multiple members.

Rick

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
> Sent: Friday, November 21, 2003 12:16 PM
> To: RPG programming on the AS400 / iSeries
> Subject: 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.
> 
> 
> _______________________________________________
> 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.
> 
>