DB2 FOR LUW / DB2FORLUW / A50 - DB2

An example SQL: 
---------------------------------------------------------------- 
SELECT LEVEL FROM DUAL CONNECT BY NOCYCLE LEVEL <= 10 
---------------------------------------------------------------- 
 
Since the virtual table DUAL has 1 row, the intermediate result 
table Hn+1 would return the same row as the one that is already 
in the hierarchical path. According to the documentation, the 
NOCYCLE keyword will not include the repeated row. This is an 
intended behaviour in DB2, which is different from Oracle 
behaviour.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.3                                           * 
****************************************************************

Rewrite the query using DB2 syntax. The following technotes may 
be of help: 
http://www.ibm.com/developerworks/data/library/techarticle/dm-05 
10rielau/ 
http://www.ibm.com/developerworks/ibmi/library/i-db2connectby/in 
dex.html

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem Fixed In 10.5.0.3

keiner bekannt / siehe Local-Fix

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

27.08.2013
28.02.2014
28.02.2014