DB2 FOR LUW / DB2FORLUW / 950 - DB2

A dynamic SQL statement may fail at execution time with SQL0138 
when REOPT is set to ALWAYS.  This can happen when the statement 
includes a SUBSTR function where the first argument is an 
untyped parameter marker and the offset and length arguments put 
the substring range outside the actual parameter marker value at 
execution time. 
 
This is similar to IZ08102 which is an APAR for stored 
procedures

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fix Pack 10                           * 
****************************************************************

Cast the untyped parameter marker to make a typed parameter 
marker, e.g.: SUBSTR( CAST( ? as VARCHAR(32672) ), <offset>, 
<length> )

Problem was first fixed in Version 9.5 Fix Pack 10

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84121 IC84610 IC87873 
follow-up : 

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

30.04.2012
11.12.2012
11.12.2012

9.5.FP10