DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* CLI0118E  INVALID SQL SYNTAX WHEN CALLING A SP WITH          * 
* PARAMETER LISTING THAT CONTAINS NEW LINE CHARACTER.          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6                        * 
****************************************************************

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

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
 

First fixed in DB2 Version 9.7 Fix Pack 6

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

Vorgänger  : APAR is sysrouted TO one or more of the following: IC77956 IC77957 
Nachfolger : 

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

04.08.2011
11.07.2012
11.07.2012

9.7.FP6