DB2 FOR LUW / DB2FORLUW / 970 - DB2

SQL0418 error can be returned if untyped parameter marker is 
used as argument for TRIM/STRIP scalar function. For example, 
the following will both fail with SQL0418 errors: 
 
BEGIN 
EXECUTE IMMEDIATE 'insert into z_test_bind values(?,?,strip(?))' 
USING 
IN '4','test','   description here      '; 
EXECUTE IMMEDIATE 'insert into z_test_bind values(?,?,trim(?))' 
USING 
IN '4','test','   description here      '; 
END@

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 9.7 Fix Pack 10                                    * 
****************************************************************

Using a CASTing function on the parameter will function as a 
work-around.

First fixed in DB2 9.7 Fix Pack 10

not known / see Local fix

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

10.12.2013
17.11.2014
17.11.2014

9.7.FP10