DB2 FOR LUW / DB2FORLUW / 910 - DB2

When a stored procedure is called from a CLI based application 
and the parameter listing has a new line character separating 
parameters, such as after PARAM2 in the following: 
 
CALL SYSPROC.DSNTPSMP('PARAM1', 'PARAM2', 
'CREATE PROCEDURE PROCNAME ( ) 
    LANGUAGE SQL 
 
The following error may occur: 
CLI0118E  Invalid SQL syntax. SQLSTATE=37000

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 v9.1 CLI based applications calling Stored Procedures    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A call to a Stored Procedure from a CLI based application    * 
* where the parameter list has a newline character separating  * 
* parameters will fail with                                    * 
* CLI0118E  Invalid SQL syntax. SQLSTATE=37000                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.1 Fixpack 11                               * 
****************************************************************

Remove the new line character and separate the parameters by 
spaces instead.

DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

First fixed in DB2 v9.1 Fixpack 11

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

05.08.2011
20.01.2012
20.01.2012

9.1.FP11