Re: Selective COMMIT
From: <stowe_at_mcs.net>
Date: 1995/05/16
Message-ID: <3paoif$t0m_at_News1.mcs.com>#1/1
Date: 1995/05/16
Message-ID: <3paoif$t0m_at_News1.mcs.com>#1/1
> billyoc_at_iii.net (Billy O'Connor) writes:
> Is there a method to commit a current block of SQL while leaving
> others uncommitted? i.e.:
>
> EXEC SQL a;
> EXEC SQL b;
> EXEC SQL c;
> EXEC SQL COMMIT c;
> Can you commit c while leaving a and b in the rollback buffer?
> TIA.
>
>>>>
In a word, NO. However, you may open multiple connections to the database to provide similar behavior.
Michael Stowe
Constellation Engineering
http://www.mcs.net/~stowe
Received on Tue May 16 1995 - 00:00:00 CEST