× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Doug,

Ok keep this link handy:

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


22012   Division by zero is invalid.


Now you have your answer!

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 10: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=i
> ssue&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.
> 
> -- 
> 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.
> 
> 


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.