Re: using subselect in embedded sql

[rick baird <rick.baird@xxxxxxxxx>]

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