DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 will report a -104 syntax error against a DECLARE CURSOR 
statement when all of the following conditions are met: 
 
- The cursor name contains one or more hyphen characters ('-'); 
- The cursor references one or more host variables. 
 
Examples: 
DECLARE CUR-C1 CURSOR FOR SELECT N1 FROM TABLE1 WHERE N1 > 
:LIMIT 
 
CREATE PROCEDURE P1(IN X INTEGER) 
LANGUAGE SQL 
DYNAMIC RESULT SETS 1 
BEGIN 
  DECLARE CUR-ABC CURSOR FOR 
    SELECT * FROM MYTABLE WHERE COL1 = X; 
 
  OPEN CUR-ABC; 
END

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users prior to DB2 V97 FP2                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* -104 FROM CURSOR DECLARATION WITH HYPHENATED CURSOR NAME     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 FP2.                                      * 
****************************************************************

Change all occurrences of the cursor name so that they do not 
use any hyphens.  The underscore character ('_') is an 
acceptable alternative.  For example: 
 
  DECLARE CUR_ABC CURSOR FOR 
    SELECT * FROM MYTABLE WHERE COL1 = X; 
 
  OPEN CUR_ABC;

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

Problem is first fixed in DB2 V97 FP2.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC67966 
follow-up : 

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

03.11.2009
22.06.2010
22.06.2010

9.7.FP2