Re: put on 7.4 TR4, now getting a SQL error

Yeah, IFNULL takes exactly 2 parameters, the 2nd being the value if the 1st is NULL. COALESCE takes any number of parameters, returns the 1st (I think) value that is not NULL, otherwise, the last if all the rest are NULL.

Everything I've done has needed only 2 parameters, still, I've used COALESCE, I guess I learned that first. But COALESCE also lines up with the 2003 SQL standards.

Cheers
Vern

On 5/31/2021 12:07 PM, x y wrote:

I use IFNULL myself...

On Mon, May 31, 2021 at 1:05 AM Patrik Schindler <poc@xxxxxxxxxx> wrote:

Hello Gerald,

Am 31.05.2021 um 03:54 schrieb Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx

:
this sql statement had a bad COALESCE, in that it was a numeric field,

but

I was replacing it with a blank...

The joy of complex SQL statements. :-)

Platform-agnostic, I sometimes found it challenging to let make the
database to what I want in one go. Then it appeared much easier to me using
temporary tables and do several processing steps. IBM i is even more easy
because you could call external programs as stored procedures. Yet, it is
tempting to unload a task to the database engine at once.

Maybe this helps with future SQL development?

:wq! PoC

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com