1) We have Sybase 12.5 ASE.
2) We have 12 stored procedures out of which 2 need transaction handling i.e. if there is error, rollback everything else commit at the end.
3) We tried using @@error & @@transtate with BEGIN TRAN, ROLLBACK TRAN & COMMIT TRAN and the later worked for a unique constraint violation.
4) Please suggest good transactional handling methods by which if any error occurs, entire transaction should rolled back else entire transaction should be commited at the end.