DB2 FOR LUW / DB2FORLUW / 970 - DB2

If your application uses CLI or JDBC to issue a dynamic 
SELECT INTO or VALUES INTO statement contained inside a 
compound statement, DB2 will report SQLCODE -109 when the 
statement is prepared.  The error occurs for SQL PL compiled 
compound statements, as well as PL/SQL anonymous blocks. 
 
 
For example, you will obtain SQLCODE -109 if you attempt to 
prepare the following compound statement via JDBC: 
 
begin 
  declare test varchar(10); 
  select 'abc' into test from sysibm.sysdummy1; 
 
  set ? = test; 
end

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If your application uses CLI or JDBC to issue a              * 
* dynamicSELECT INTO or VALUES INTO statement contained inside * 
* acompound statement, DB2 will report SQLCODE -109 when       * 
* thestatement is prepared.  The error occurs for SQL PL       * 
* compiledcompound statements, as well as PL/SQL anonymous     * 
* blocks.For example, you will obtain SQLCODE -109 if you      * 
* attempt toprepare the following compound statement via       * 
* JDBC:begindeclare test varchar(10);select 'abc' into test    * 
* from sysibm.sysdummy1;set ? = test;end                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 2.                       * 
****************************************************************

As a workaround, convert the compound statement to an SQL 
procedure, and then call the procedure from CLI or JDBC.  For 
example: 
 
create or replace procedure workaround(out result varchar(10)) 
begin 
  select 'abc' into result from sysibm.sysdummy1; 
 
end

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

This problem was first fixed in DB2 Version 9.7 Fix Pack 2.

See LOCAL FIX.

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

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

05.02.2010
05.07.2010
05.07.2010

9.7.FP2