How can i make many statement in the same transaction :

```
update .....;--s1
update .....;--s2
update .....;--s3
COMMIT;

```

if an error occur in s2 rollback s1, if an error occur in s3 rollback s2 and s1;