IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50

Create a view using UNION ALL: 
 
CREATE VIEW   v1 (c2) AS 
   SELECT x0.c2 FROM t1 x0 
UNION ALL 
   SELECT x1.c2 FROM t1 x1 ,  t2 x2 WHERE (x1.c1 = x2.c1 ) ; 
 
and from a client program have a cursor: 
 
  SELECT c2 FROM v1 
 
the program uses the cursor repeatedly, every time inside a 
different transaction. 
 
If during one of these transactions, a problem such as a lock 
timeout occurs and a rollback occurs, the program starts over 
with a new transaction, the cursor will not work anymore even 
if the lock is removed. 
 
When using views without a UNION ALL, as soon as the lock is 
removed, the cursor can be used again.

**************************************************************** 
* USERS AFFECTED:                                              * 
* IDS users using UNION ALL cursor queries that will need view * 
* materialization                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Once cursor open fails, repeated attempts to open it from    * 
* the same session will also fail.                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IDS 11.50.xC5 or above.                           * 
****************************************************************

Problem first fixed in IDS 11.50.xC5

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

30.04.2009
27.07.2009
27.07.2009

11.50.xC5