DB2 FOR LUW / DB2FORLUW / A10 - 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 DB2 version 10.1 fix pack 1                       * 
****************************************************************

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

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 version 10.1 fix pack 1

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

14.06.2012
19.11.2012
19.11.2012