RE: SQL Select from a record -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.