RE: AW: embedded sql session error in subfile

There's plenty of info out there.

Here's a good article:

http://www.as400network.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=11360&channel=art&subart=issue&issueid=514

or http://tinyurl.com/a2xsq


HTH,

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:32 AM
> To: RPG programming on the AS400 / iSeries
> Subject: 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.
> 
> -- 
> 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.
> 
>