×
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.
When I first started writing imbedded SQL, I had that problem. It turned
out the variable receiving the SUM value wasn't large enough to receive the
result. If you use SQL, learn the error codes and check for them!
Regards,
Guy
Tom Liotta
<qsrvbas@netscape. To: rpg400-l@xxxxxxxxxxxx
net> cc:
Sent by: Subject: Re: Classic Traps -- I need your input!
rpg400-l-bounces@m
idrange.com
04/02/2008 04:51
PM
Please respond to
RPG programming on
the AS400 /
iSeries
Scott Klement wrote:
Folks, I'm working on an article that's tentatively titled "Classic
Traps and How to Avoid Them". The general idea is to discuss the classic
mistakes that programmers make while programming, and (where necessary)
explain how to avoid that.
One just came to mind that we see here regularly -- "The exact same
statement works in interactive SQL. Why doesn't it work in my program?"
Well... almost always it's because it's _not_ the "exact same
statement." Often there are host variables or other elements that
require changing between the two.
Use statements in the environments for which they are intended. And
if _anything_ changes, then start looking there for the resolution.
Tom Liotta
--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone 253-872-7788 x313
253-479-1416
Fax 253-872-7904
http://www.powertech.com
--
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.
midrange.com
