DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 CLI may fail to count number of parameter markers if SQL 
statements include comment(s) with multi-byte characters. CLI 
Application receives CLI0612E when it tries to bind a parameter 
to the parameter markers. 
The following steps illustrates one of the scenario to cause 
this problem. 
. 
1. We have following query includes Japanese comment string. 
. 
 select * from org 
 where 
  deprnumb = ? and 
  /*<4 Japanese Characters>*/ 
  manager = ? 
. 
2. Prepare the statement and set values by using Legacy JDBC 
   Driver. 
. 
 PreparedStatement stmt = conn.prepareStatement(sql); 
 stmt.setInt(1, 10); 
 stmt.setInt(2, 160); 
. 
3. Second setInt() fails with CLI0612E because SQLNumParams 
   reports the statement includes only one parameter marker, 
   and CLI thinks index 2 is out of range. 
. 
Exception: 
 COM.ibm.db2.jdbc.DB2Exception: IBM JDBC Driver CLI0612E 
 Invalid parameter number. SQLSTATE=S1093 
. 
CLI trace: 
 SQLPrepareW( hStmt=1:1, pszSqlStr="select * from org ...) 
 SQLPrepareW( ) 
    <--- SQL_SUCCESS 
 SQLNumParams( hStmt=1:1, pcPar=&0007fc48 ) 
 SQLNumParams( pcPar=1 )   // This should be 2. 
    <--- SQL_SUCCESS

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who uses multi-bytes characters in SQL comments.       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 CLI may fail to count number of parameter markers if SQL * 
*                                                              * 
* statements include comment(s) with multi-byte characters.    * 
* CLI                                                          * 
* Application receives CLI0612E when it tries to bind a        * 
* parameter                                                    * 
* to the parameter markers.                                    * 
* The SQL might fails with SQL0104N.                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
****************************************************************

Please remove SQL comments which contains multi-byte characters.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 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
 

Problem was first fixed in Version 9.7 Fixpack 1

keiner bekannt / siehe Local-Fix

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

01.09.2009
17.12.2009
17.12.2009

9.7.FP1