DB2 FOR LUW / DB2FORLUW / 980 - 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:                                              * 
* User prior to DB2 V98 FP3.                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* -104 FROM CURSOR DECLARATION WITH HYPHENATED CURSOR NAME     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 to V98 FP3.                                      * 
****************************************************************

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.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

First fixed in DB2 V98 FP3.

not known / see Local fix

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

15.04.2010
11.01.2011
11.01.2011

9.8.FP3