DB2 FOR LUW / DB2FORLUW / A50 - DB2

An unqualified reference to scalar function TRUNCATE with 2
arguments incorrectly resolves to SYSFUN.TRUNCATE instead of
SYSIBM.TRUNCATE when the first argument is a numeric data type
other than DECFLOAT, and the second argument is a string.  As a
consequence, the resulting datatype may not be as expected.  For
example:

TRUNCATE(DECIMAL, VARCHAR)

resolves to SYSFUN.TRUNCATE(FLOAT, INTEGER) and returns FLOAT.
The expected result is that it should resolve to
SYSIBM.TRUNCATE(DECIMAL,INTEGER) and return a DECIMAL result.

The same applies to the synonym TRUNC.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Uprade to Db2 version 11.1                                   *
****************************************************************

Explicitly qualify the function with SYSIBM.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

31.10.2018
01.11.2018
01.11.2018