Hi all,

I'm using Sybase SQL Anywhere 10.0.1.3722

I have a question regarding the use of BEGIN ATOMIC:

As I understood the database has to run in CHAINED MODE to use an atomic block, because I can not use commit/rollback inside it.
So whats the use of the atomic block if I have to execute commit/rollback after exiting that block and with the database being in chained mode everything since the last commit/rollback is one big atomic operation anyway.
It seems to me that marking the BEGIN-END-block as 'atomic' has no effect.

Thanks in advance for any explanations.

Regards

Marco