DB2 - Problembeschreibung
Problem IC64994 | Status: Geschlossen |
SYSIBM.INSERT AND SYSIBM.OVERLAY SCALAR FUNCTIONS RETURN SQL0138N, IF LENGTH>LENGTH(SOURCE-STRING)-START+1. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
The scalar functions SYSIBM.INSERT and SYSIBM.OVERLAY do not allow a length argument that is greater than the length of the string-expression - start + 1. This behaviour is incompatible with SYSFUN.INSERT, and exisitng applications might fail with SQL0138N. For example: $ db2 values INSERT('12345', 3, 4, 'abc') 1 -------- SQL0138N A numeric argument of a built-in string function is out of range. SQLSTATE=22011 As SYSIBM.OVERLAY works as the same manner as SYSIBM.INSERT, OVERLAY also needs to be changed.SYSIBM.INSERT and SYSIBM.OVERLAY will allow any 0 < length < 2147483647 (maximum positive INTEGER value), if it means that it is beyond the end of source-string, we will replace everything starting at "start" position. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users who use SYSIBM.INSERT or SYSIBM.OVERLAY scalar * * functions. * **************************************************************** * PROBLEM DESCRIPTION: * * The scalar functions SYSIBM.INSERT and SYSIBM.OVERLAY do not * * allow a length argument that is greater than the length of * * the string-expression - start + 1. * * This behaviour is incompatible with SYSFUN.INSERT, and * * exisitng applications might fail with SQL0138N. * * For example: * * * * $ db2 values INSERT('12345', 3, 4, 'abc') * * * * 1 * * -------- * * SQL0138N A numeric argument of a built-in string function * * is out of range. * * SQLSTATE=22011 * * * * As SYSIBM.OVERLAY works as the same manner as SYSIBM.INSERT, * * OVERLAY also needs to be changed.SYSIBM.INSERT and * * SYSIBM.OVERLAY will allow any 0 < length < 2147483647 * * (maximum positive INTEGER value), if it means that it is * * beyond the end of source-string, we will replace everything * * starting at "start" position. * **************************************************************** * RECOMMENDATION: * * Please upgrade to version 9.5 fixpack 6 or later. * **************************************************************** | |
Local-Fix: | |
Please use SYSFUN.INSERT instead of SYSIBM.INSERT (default in v9.5 or later). | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.5 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65010 IC68468 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 06.12.2009 31.08.2010 31.08.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |