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

I NEED TO POINT OUT.

this was NOT in TR4.

this was in DB PTF group 13.

this morning we found a program not functioning, getting a -678 SQLCOD:

.... CASE when charfld1 = 'A' and numericdate = 20391231 then
int(current date + 7 days) else ' ' end as Newnumericdate
...

when we changed the "else ' ' " to "else 0 ", the program
started to function again. with the developer commenting "we may be
having more rows returned than we did before"


On Tue, Jun 1, 2021 at 8:38 AM Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
wrote:

After scanning our source, we only found 2 instances of incorrect
typing. IBM also pointed out that this error may pop up not only on the
COALESCE, but on any place where we may have a bad type cast.


On Mon, May 31, 2021 at 2:07 PM Patrik Schindler <poc@xxxxxxxxxx> wrote:

Hello,

Am 31.05.2021 um 19:07 schrieb x y <xy6581@xxxxxxxxx>:

I use IFNULL myself...

I'm not in particular talking about IFNULL, but complex (for the human
eye) to parse, multiline and nested statements and substatements.

: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