suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    das ultimative Tool für Informix

    pfeil  
Neueste VersionenFixList
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT18318 Status: Geschlossen

CURSOR ON DYNAMIC SQL RETURNED -661 INSTEAD OF -26053

Produkt:
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10
Problembeschreibung:
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;
Problem-Zusammenfassung:
****************************************************************
* USERS AFFECTED:                                              *
* Informix user with dynamic SPL cursor                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.12.2016
10.07.2017
10.07.2017
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC9
Problem behoben lt. FixList in der Version
Informix EditionenInformix Editionen
Informix Editionen
DokumentationDokumentation
Dokumentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download