|
Problem IC74416
|
Status: Closed |
CALL statement containing both parameter markers and literals are failing against z/OS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The apar was opened to address 2 issues:
1) SQLDescribeParam on a PREPARED CALL statement against z/OS
that is having both paramter markers and literals is throwing
CLI0150E error.
2) when calling the CALL Procedure with both literals and '?'
parameters, SQL0440N error is thrown
Above issues are introduced in v9.7 FP1 and same would be seen
in FP2 and FP3. Both the issues have been fixed in v9.7 FP4 |
| Problem Summary: |
CALL statement containing both paramter markers and literals are
failing against z/OS. |
| Local Fix: |
|
| available fix packs: |
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 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
|
| Solution |
fixed in fixpak4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.02.2011
12.05.2011
14.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
