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



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.