|
Problem IC95395
|
Status: Closed |
CALL PROCEDURE FAILS FROM CLPPLUS COMMAND PROMPT WHEN ARGUMENT VALUE CONTAINS OPEN OR CLOSED PARATHESIS '(' / ')' AND ',' |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
This is a general defect, related to calling the stored
procedures from clpplus prompt.
1. Problem description
Call procedure fails when executed from clpplus command prompt
when argument value contains paranthesis '(' / ')' and ',' as
part of string like below
SQL> call
sysproc.systs_create('PSSAPL','LEGALMATTER_TEXT','PSSAPL.LEGALMA
TTER(MATTERNAME)','UPDATE FREQUENCY D(*) H(*)
M(0,30)','en_US',?);
[jcc][10143][10845][3.63.75] Invalid parameter 1: Parameter is
not set nor registered. ERRORCODE=-4661, SQLSTATE=42815
NOTE : Error not specific to this stored procedure, but it is
related to general procedure. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* before v10.5 fp3 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
28.02.2014
28.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
