DB2 FOR LUW / DB2FORLUW / 970 - DB2

TO_CHAR and other built-in functions could not be pushed down 
under following conditions: 
1. the built-in functions have an internal format with a NULL as 
parameter 
2. the server's server option db2_null_in_select is set to N, 
such as the default setting of AS400 data sources

**************************************************************** 
* USERS AFFECTED:                                              * 
* all platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IFS version v9.7.9                                * 
****************************************************************

Set the server option db2_null_in_select to Y

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

v97fp9, the built-in functions can be pushed down and 
performance can be improved.

Set the server option db2_null_in_select to Y

forerunner  : APAR is sysrouted TO one or more of the following: IC93252 IC95398 
follow-up : 

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

07.05.2013
16.12.2013
16.12.2013

9.7.9,
9.7.FP9