Re: Informix equivalent of savepoint

JULIEJ wrote: > In Informix is there an equivalent command for the Oracle > savepoint command? > ...snip.... > After sqlstmt10, I want to rollback upto sqlstmt5. How would I do it? > > TIA, > Julie Joseph Other people have said this is not possible. However look into the newer SQL features in 7.xx including the 'CONNECT' and SET CONNECTION commands. I have not had time to test these but it looks like you may be able to set 2 connections to the same server and switch between them, effectively giving you 2 concurrent transactions - one could start at stmt1 and one after stmt5, you either commit both or just the first (use the second transaction for items 6 thru 10). Good luck - let us know if it works - Paul R. (pjredman@compuserve.com)