|
Problem IT17815
|
Status: Closed |
COMMIT WORK RETURNS -745 WHEN TRANSACTION CONTAINS QUERIES ON TABLES WITH SELECT TRIGGERS AND CURSOR WITH HOLD SPANS TRANSACTION
|
| product: |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 |
| Problem description: |
If you have select triggers within that are fired within a
transaction and there is a cursor created with hold
that spans the transaction, the commit work will return a -745
and rollback the transaction.
For instance:
Tables tab1, tab2 and tab3 all created with select triggers
declare curs1 cursor with hold
open curs1
fetch 1 row
call procedure that executes:
begin work;
foreach select from tab2
forecach select from tab3
insert into tab4
end foreach
end foreach
commit work |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* commit work when select triggers on tables and cursor with *
* hold spans transaction *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC8 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.11.2016
09.12.2016
09.12.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC8
|
| Problem solved according to the fixlist(s) of the following version(s) |
