RE: AW: embedded sql session error in subfile

Charles,
I hate to do this, I really do because I do not like looking like an idiot 
but I do not know what SQLSTT is or how to check it.

Would you or someone else be kind enough to assist?



On Wed, 27 Jul 2005 09:17:34 -0400, Wilt, Charles wrote
> Douglas,
> 
> Repeat after me....
> 
> "I must check SQLSTT after each embedded SQL statement."
> 
> Now, add the code to check SQLSTT and let us know what the error is.
> 
> 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 Douglas W. Palme
> > Sent: Wednesday, July 27, 2005 9:10 AM
> > To: RPG programming on the AS400 / iSeries
> > Subject: Re: AW: embedded sql session error in subfile
> > 
> > 
> > Bruce Guetzkow wrote: 
> > 
> > "You need to specify the same fields for Order By and Group 
> > By...SQL is VERY 
> > fussy about that."
> > 
> > What is the difference between running the sql statement in 
> > an rpgle versus 
> > the interactive sql utility (strsql)?
> > 
> > I used the exact same select statement in the interactive as 
> > I had in the 
> > program and it ran ok....
> > 
> > I know its going to be something very simple that I am screwing up....
> > 
> > Douglas
> > 
> > -- 
> > 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.
> > 
> >
> 
> -- 
> 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.


If you bought, it was hauled by a truck - somewhere, sometime.