Re: Selective COMMIT
From: <Enrico>
Date: 1995/05/18
Message-ID: <D8r25p.6G4_at_online.tmx.com.au>#1/1
Date: 1995/05/18
Message-ID: <D8r25p.6G4_at_online.tmx.com.au>#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.
>
>
>>>>
Try looking at SAVEPOINT.
Regards,
Enrico
--- Enrico Soldani clemnet_at_clemenger.com.au Clemenger/BBDO +61 2 925 5255Received on Thu May 18 1995 - 00:00:00 CEST