Re: Locking outside COMMIT WORK

Bryan Tonnet wrote: > > One of the real frustrations I have had in the past is with situations > where it would be beneficial to maintain locks outside of a transaaction. > > A hypothetical might be; > > set isolation to repeatable read> select 'sql statement' into temp temp_table Sorry, I don't understand this part. > > ....... > > Is there a non-bodgy way around this, or is it one of those things we just > have to learn to live with. Up till now I've done the latter, but maybe > someone here can bump me up to a new awareness level [or at least give me > some tips on motorcycle maintenance]. > There is a possible solution. Check out Informix Guide to SQL: Tutorial, Chapter 7, Section: Hold Cursor. As far as I know this is the only way to hold a cursor when committing a transaction. I don't remember what kind of problems you may encounter. You probably still have to tweak it for your need. Since I don't understand your program, I can't make further suggestions. Chao