Does anyone know as how to implement two-phase commit in Sybase, this
is for version 12.0 on Solaris. I do know that in oracle this is
already by default but for Sybase I cant find much info on it

Thank you so much
Teresa

2-phase commit (also known as SYB2PC) has been supported in Sybase ASE for
many, many years (at least since version 4 in 1990). To use this, you must
perform certain library calls in you client application. For full details
see http://sybooks.sybase.com/cng1250e.html and read the document
http://sybooks.sybase.com/cng1250e.html.

Note that since ASE 12.0, you can also use distributed transactions with
ASE's DTM features. For details, go to sybooks.sybase.com/asg1251e.html and
read the document "Using Adaptive Server Distributed Transaction Management
Features".

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Teresa" <tpreto7 (AT) sapo (DOT) pt> wrote