DB2 CONNECT / DB2CONNCT / 970 - DB2

SQL query built using Query Builder in Microsoft Visual Studio 
when executed against a DB2 database using IBM DB2.NET provider 
can result in a CLI0100E error when the query has certain 
keywords, such as "CASE", "WHEN", "THEN", "ELSE", and/or "END". 
 
AdoDotNetDataSourceInformation (not an IBM method) calls 
GetSchema (one of IBM's methods) to get a ReservedKeyword list. 
The GetSchema call does indeed generate the list but the 
keywords "CASE", "WHEN", "THEN", "ELSE", "END" are not in the 
list, so the designer does not treat those as reserved keywords. 
 
 
Queries work fine from DB2 command line, but only fails from 
Query builder and Microsoft Visual Studio using DB2 .NET 
provider. 
 
For example: 
SELECT CODE, CASE COUNTRY WHEN 'XX' THEN 'XXXX' WHEN 'YY' THEN 
'YYYY' ELSE 'ZZZZ' END AS "SOURCE" 
FROM DB2ADMIN.COUNTRY WHERE (CODE = ?) 
 
SQL Execution Error. 
 
Executed SQL statement:SELECT CODE, CASE COUNTRY WHEN 'XX' THEN 
'XXXX' WHEN 'YY' THEN 'YYYY' ELSE 'ZZZZ' END AS "SOURCE" 
FROM DB2ADMIN.COUNTRY WHERE (CODE = ?) 
 
Error Source: IBM.Data.DB2 
Error message; Error [07001][IBM] CLI0100E Wrong number of 
parameters. SQLSTATE=07001 
 
 
This APAR fixes the problem in the DB2 .NET provider.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V9.7 users on Windows OS                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL query built using Query Builder in Microsoft Visual      * 
* Studio when executed against a DB2 database using IBM        * 
* DB2.NET provider can result in a CLI0100E error when the     * 
* query has certain keywords, such as "CASE", "WHEN", "THEN",  * 
* "ELSE", and/or "END".                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP 6                                     * 
****************************************************************

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
 

First fixed in DB2 V9.7 FP 6

not known / see Local fix

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

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

03.02.2012
05.06.2012
05.06.2012

9.7.FP6