home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC73316 Status: Geschlossen

-104 FROM CURSOR DECLARATION WITH HYPHENATED CURSOR NAME WHICH USES DB2
KEYWORD BEFORE THE HYPHEN

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
This is a similar problem to IC64319. 
IC64319 says that : 
----------------------- 
 
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. 
 
However there are a class of cursor names which that this APAR's 
fix fails to address.  You will still encounter a syntax error, 
SQL0104N, 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. 
- The part of the cursor name before the first hyphen is a DB2 
keyword; for example, C or STAGING. 
 
There are many identifiers that DB2 considers to be either an 
identifier or a keyword, depending on context.  Although it is 
not practical to provide an exhaustive list of these identifiers 
here, if you are running 9.7 FP2 and still encountering this 
problem, your cursor name likely begins with one of them.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users on DB2 V9.7                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* This is a similar problem to IC64319.                        * 
*                                                              * 
* IC64319 says that :                                          * 
*                                                              * 
* -----------------------                                      * 
*                                                              * 
*                                                              * 
*                                                              * 
* 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.          * 
*                                                              * 
*                                                              * 
*                                                              * 
* However there are a class of cursor names which that this    * 
* APAR's                                                       * 
* fix fails to address.  You will still encounter a syntax     * 
* error,                                                       * 
* SQL0104N, 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.          * 
*                                                              * 
* - The part of the cursor name before the first hyphen is a   * 
* DB2                                                          * 
* keyword; for example, C or STAGING.                          * 
*                                                              * 
*                                                              * 
*                                                              * 
* There are many identifiers that DB2 considers to be either   * 
* an                                                           * 
* identifier or a keyword, depending on context.  Although it  * 
* is                                                           * 
* not practical to provide an exhaustive list of these         * 
* identifiers                                                  * 
* here, if you are running 9.7 FP2 and still encountering this * 
*                                                              * 
* problem, your cursor name likely begins with one of them.    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to the next release of DB2,                          * 
* as the APAR may be fixed in the next release                 * 
****************************************************************
Local-Fix:
If possible, change the hyphens ('-') in the cursor name to 
something else, like underscores ('_').
Lösung
This problem may be fixed in the next release of DB2(not in 
V9.7)
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.12.2010
13.03.2012
13.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version