On Wed, 15 May 2002 08:16:09 -0000 "synecticsza" <vince@...>
wrote:

> The problem lies in your COMMIT/ROLLBACK statements. You are using:
> EXEC SQL COMMIT HtransIns;
>
> while you should be using
>
> EXEC SQL COMMIT TRANSACTION HtransIns;

Doh!

I should have read the Embedded SQL guide a bit closer...

Thanks Vince