|
Problem IC73316
|
Status: Closed |
-104 FROM CURSOR DECLARATION WITH HYPHENATED CURSOR NAME WHICH USES DB2 KEYWORD BEFORE THE HYPHEN |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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 ('_'). |
| Solution |
This problem may be fixed in the next release of DB2(not in
V9.7) |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.12.2010
13.03.2012
13.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
