RE: using subselect in embedded sql

[Max.Clarkson@xxxxxxx]

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