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



Max,

What you're telling us the code is vs. what the error message is telling us 
doesn't match up.

Post the actual code please.



Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of 
> Max.Clarkson@xxxxxxx
> Sent: Wednesday, August 17, 2005 10:01 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: using subselect in embedded sql
> 
> 
> Hi Rick,
> 
> On taking the option that would run that piece of embedded 
> sql the screen returned nil records...
> 
> a look at the job log revealed the message:  
> 
> "Column E1ACDT not in specified tables."
> 
> 
> (this is a field from the subselect file LEVNAC1L) 
> 
> cheers,
> max
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of rick baird
> Sent: 17 August 2005 14:25
> To: RPG programming on the AS400 / iSeries
> Subject: Re: using subselect in embedded sql
> 
> 
> Max,
> 
> What exactly is your error?  is it runtime or compile?
> 
> On 8/17/05, Max.Clarkson@xxxxxxx <Max.Clarkson@xxxxxxx> wrote:
> > 
> > Hello!
> > 
> > i am having a problem getting a simple sql command which 
> works fine from STRSQL to work when i embed it in RPG!!
> > 
> > Here's the statement:
> > 
> > --------------------------------------------------------
> > 
> >  Select distinct * from
> >  LEVNTN0P where ENEVRF in
> >  (Select E1EVRF from LEVNAC1L)
> > 
> > --------------------------------------------------------
> > 
> > it seems to fall over because LEVNAC1L is not defined as a file...
> > 
> > BUT i really don't want to have to include it with the file 
> definition because i'm selecting * and my FETCH statement 
> goes INTO the file described data structure...    (one 
> solution would be to move the subselect to the FROM list) and 
> list each individiual field name in the SELECT statement... 
> but this is far from ideal.
> > 
> > This is for a display subfile program where the user has 
> the option to select different sorts and selects and i soft 
> generate a new sql depending on their choices.   This is (so 
> far) the only request which necessitates a subselect.
> > 
> > 
> > can anyone offer any suggestions?
> > 
> > thanks in advance,
> > max
> > 
> > --
> 
> -- 
> 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.
> 
> 


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.