DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 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
 

not known / see Local fix

The problem is fixed

forerunner  : APAR is sysrouted TO one or more of the following: IC84293 
follow-up : 

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

24.11.2011
29.03.2013
29.03.2013