DB2 FOR LUW / DB2FORLUW / A10 - DB2

The built-in scalar functions INSTR, LOCATE, LOCATE_IN_STRING 
and POSITION may return an incorrect result or fail with SQLCODE 
-901 when CODEUNITS16 or CODEUNITS32 is specified, e.g.: 
 
  values LOCATE(LOWER('eq'),'1eq3', CODEUNITS16) 
 
  1 
  ----------- 
            0 <- Wrong, should be 2 
 
    1 record(s) selected. 
 
  values LOCATE(UPPER('e'),'1EQ3', CODEUNITS32) 
  SQL0901N  The SQL statement or command failed because of a 
  database system error. (Reason 
  "(POSSTR: unable to precompile search pattern)".) 
  SQLSTATE=58004 
 
This can happen when the search-string is an expression that 
includes only literals and built-in functions.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 fix pack 4                       * 
****************************************************************

Replace the search-string expression with a simple string 
literal

DB2 Version 10.1 Fix Pack 4 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 4

not known / see Local fix

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

17.12.2013
02.06.2014
02.06.2014