|
Problem IC84121
|
Status: Closed |
DYNAMIC SQL EXECUTION FAILS WITH SQL0138 WITH REOPT=ALWAYS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 fix pack 7 *
**************************************************************** |
| Local Fix: |
Cast the untyped parameter marker to make a typed parameter
marker, e.g.: SUBSTR( CAST( ? as VARCHAR(32672) ), <offset>,
<length> ) |
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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
|
| Solution |
First fixed in DB2 version 9.7 fix pack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.06.2012
17.12.2012
17.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
