RE: using subselect in embedded sql

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