DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 fix pack 10                       * 
****************************************************************

Replace the search-string expression with a simple string 
literal

First fixed in DB2 version 9.7 fix pack 10

not known / see Local fix

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

17.12.2013
12.11.2014
12.11.2014

9.7.FP10