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?
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.