by Denha.. » Sun, 31 Dec 1899 09:00:00
Rudolph
Your problem is caused by the cursor being closed after the commit.
You will find
somewhere in the manuals (about commit I think) that it says that
when a commit is
performed, all cursors get closed.
To get around this you need to declare you cursor with hold. I
cannot remember the exact
syntax, it is something like this (check the manual):
Foreach TxFT With Hold For
Select.....
This should get you out of difficulties.
Mark
1. begin works and commit works in storeprocs
I am new to informix .We are working on informix 7.1.
I want to know if I can begin work and commit inside a storeproc.
Before you answer here is the problem.It is in a foreach loop.I
want to process transactions that I get with the foreach select
statement and these transactions is in groups of 5 transaction
that must be committed together.If one of these is wrong it must be
rolled back otherwise it must be committed.
here
--
\\:// http://www.geocities.com/Area51/9680/
------------ooO-(_)-Ooo------------------------------------------
.oooO
( ) Oooo. Rudolph Terblanche
-------\ (----( )----------------------------------------------
\_) ) /
(_/ A Harmless instrument in the Hands of a Fool,
is DANGEROUS !!!!
2. Calling a user function that returns a table
4. ISQL Begin Work & Commit Work
7. BEGIN/COMMIT work in Stored Procedure
8. BEGIN TRANSACTION is working for MSACCESS but not working for SQL Server
9. BEGIN WORK/COMIT WORK in stored procedure
10. begin/end begin tran/commit in while
11. How to do a begin work, commit work in esql ?