RE: Embedded SQL with Coalesce -- RPG400-L

× 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.

Kurt, Good guess. I still receive the error either way.

Jonathan , You're right it was defined as character. I had great hopes for this one but still receive the error. I should only need the coalesce on the Declare statement not the fetch, right?

Tom, the phones are signed numeric and so I tried the + signs. It seems that a zero shouldn't need to have a sign but it was worth a shot.

Thanks but so far not any different.

HTH,
TIA,
Thanks,
Whichever applies

Dave B

"It is not real work unless you would rather be doing something else." J.M.BARRIE

Any questions, let me know please.

Thanks,

Dave Boettcher
262.653.2520

"It is not real work unless you would rather be doing something else." J.M.BARRIE

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Anderson, Kurt
Sent: Tuesday, May 29, 2012 4:09 PM
To: RPG programming on the IBM i / System i
Subject: RE: Embedded SQL with Coalesce

I've used coalesce in embedded SQL w/o issue.

Random guess: is it that you have a sign on the 0? Try w/o the +?

-Kurt

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.