| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC84350 | Status: Closed |
CLI0100E SQLSTATE 07001 RETURNED FROM VISUAL STUDIO QUERY BUILDER USING DB2.NET PROVIDER | |
| product: | |
DB2 CONNECT / DB2CONNCT / A10 - DB2 | |
| 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". 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. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 on Windows * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.1 FP 1 or higher * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in DB2 V10.1 FP 1 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.06.2012 06.11.2012 06.11.2012 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.1 |
|
| 10.5.0.1 |
|