Re: Convert 4GL-programs to work with databases in transaction

From: "Kai Andersen" <andersen@dpd.de> > >we have a problem concerning Informix 4GL and the database with >transactions. >Since we must change to databases with transaction recording, it is now >necessary that CURSORS ... FOR UPDATES and "LOCK .." commands must be >done in one transaction. However, when a COMMIT WORK is executed it seems >that at this time all existing cursors will be closed. >A further accessing to this cursor (eg. with FETCH) then results in the >error >"-400 unopen cursor". >Consequently it seems to be impossible to use, "COMMIT WORK" in procedures, >since this has unforeseeable results to the calling programs. >I hope anybody have a solution or a workaround for this problem. WITH HOLD? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

> > WITH HOLD? > ______________________________________________________ Hello together, nice hint, but this isn't very practical. So I have to change ALL programs and procedures witch are calling a procedure with LOCK respective COMMIT WORK. Are there any other solution, where I don't need to modify the calling programms? Thanks in advance, Kai Andersen. ************************************** DELICom DPD Deutscher Paket Dienst GmbH & Co. KG Wailandtstrasse 1, D-63741 Aschaffenburg Tel.: +49 (0)6021/492-6040 Fax: +49 (0)6021/492-6502 Email: Kai.Andersen@dpd.de Internet: Http://www.dpd.de **************************************