|
Problem IC73014
|
Status: Closed |
-104 FROM CURSOR DECLARATION WITH HYPHENATED CURSOR NAME WHICH USES DB2 KEYWORD BEFORE THE HYPHEN |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 Fix Pack 3 and below *
****************************************************************
* 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 DB2 V9.7 Fix Pack 4 *
**************************************************************** |
| Local Fix: |
If possible, change the hyphens ('-') in the cursor name to
something else, like underscores ('_'). |
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem firest fixed in DB2 V9.7 Fix Pack 4 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73316
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.12.2010
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
