DB2 FOR LUW / DB2FORLUW / A10 - DB2

Compiling a query that references an inlined SQL function in a 
LIKE pattern expression fails with the following error: 
 
SELECT * FROM T WHERE C1 LIKE SQLFUNC(C2) 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Unknown 
function 
protocol".)  SQLSTATE=58004

Move the SQL function reference into the FROM clause, for 
example: 
SELECT * FROM T, TABLE( VALUES( SQLFUNC(C2) ) ) F(P) WHERE C1 
LIKE F.P

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
 

keiner bekannt / siehe Local-Fix

The problem fixed

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

13.06.2012
29.03.2013
29.03.2013