IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10

Using a cursor for a  dynamic SQL statement where in the fetch
loop of the open
cursor a transaction close happened and a new transaction is
started, the next
fetch of the cursor returned the not so meaningful error -661.

Logic looks like this :

  prepare stmt from "select * from foo";
  declare curs cursor for stmt;
  open curs;
  while (1 = 1)
     -- this cursor gives -661 the second iteration, should give
-26053 or something
     -- works correctly if it is declared as a cursor with hold
     fetch curs into var;
     if (sqlcode == 100) then
       exit;
     end if
     let i = i + var;
     execute procedure something_with_transactions();
  end while
  close curs;
  free curs;
  free stmt;

****************************************************************
* USERS AFFECTED:                                              *
* Informix user with dynamic SPL cursor                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************

not known / see Local fix

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

08.12.2016
10.07.2017
10.07.2017

12.10.xC9