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.

keiner bekannt / siehe Local-Fix

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

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

03.11.2009
22.06.2010
22.06.2010

9.7.FP2