RE: AW: embedded sql session error in subfile

For SQL State information:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/html_nav/info/rzala/rzalaccl.htm

Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Douglas W. Palme
Sent: Wednesday, July 27, 2005 9:20 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: AW: embedded sql session error in subfile


Charles,
I placed an if statement to check for the SQLSTT and it returned a 00000 
after it executed the fetch statement it shows a value of 22012 and no 
records where passed to the variables.



On Wed, 27 Jul 2005 09:44:05 -0400, Wilt, Charles wrote
> 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=51
4
> 
> 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.
> > 
> >
> 
> -- 
> 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.