| 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 IT18649 | Status: Closed |
CLP CALL STATEMENT IN DB2 V11.1 IS BEHAVING DIFFERENTLY FROM PREVIOUS VERSIONS AND IT RESULTS IN SQL0433N. | |
| product: | |
DB2 CONNECT / DB2CONNCT / B10 - DB2 | |
| Problem description: | |
Example :
when calling it with db2 connect 10.5 (and all formerly used
Versions) it can be done with either way:
call sample02.example('AB','9',1);
or
call sample02.example('AB',9,1);
both will give a valid result.
With db2 connect v11.1 error is generated for both the cases.
Calling
call sample02.example('AB','9',1);
results in SQL0433N.
while
call sample02.example('AB',9,1);
gives
SQL0443N. The diagnostic text is: "SQLCODE: 100"
But when calling is done in this way with db2 v11.1, it will
work.
call sample02.example(AB,9,1); | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
| Local Fix: | |
Server treats the quote also as part of data. So, removing the quote will give the expected output. | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.01.2017 23.06.2017 23.06.2017 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
