DB2 FOR LUW / DB2FORLUW / 970 - DB2

CALL Procedure command of more than 64K size throws SQL0104N or 
SQL0440N error when executed using CLP. 
 
Suppose in file foo.clp, there is a CALL statement with more 
than 64K size, then while execution, we get the below error: 
 
$ db2 -tvf foo.clp 
 
SQL0104N  An unexpected token "CALL" was found following 
"BEGIN-OF-STATEMENT". 
Expected tokens may include: "<call>". SQLSTATE=42601 
 
or 
 
SQL0440N  No authorized routine named "<routine-name>" of type 
"<routine-type>" having compatible arguments was found.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Vast sql statement fails with SQL0104N error on CLP session  * 
* but the compound statements including the target statement   * 
* can work well.                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.7 FixPak 6                          * 
****************************************************************

To call the statement in a compound statement

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
 

Problem was first fixed in Version 9.7 FixPak 6

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.08.2011
11.06.2012
11.06.2012

9.7.