RE: SQL Select from a record

["Wills, Mike N. (TC)" <MNWills@xxxxxxxxxxxxxx>]

I knew about this, but I was hoping there was a better way. I decided to go
this route as it is the easiest. 



Mike Wills
Lawson Programmer/Administrator
Taylor Development
Email: mnwills@xxxxxxxxxxxxxx
Direct Line: (507) 625-3187

-----Original Message-----
From: Chevalier, Rick [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx] 
Sent: Friday, November 21, 2003 11:56 AM
To: RPG programming on the AS400 / iSeries
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.