[freetds] begin atomic in procedures

Pickett, David David.Pickett at phlx.com
Fri Nov 25 08:51:12 EST 2005


Well, my Sybase is getting dusty, and changing the name and polarity of
attributes, like from 'autocommit on' to 'temporary option chained off',
keeps riff-raff like me out of the trade!  I wonder what is 'temporary' or
'chained' about an implicit transaction?

http://www1.4js.com/html/supp/documentation/olgenerodoc/fjs-fgl-1.31.1a-manu
al-html/User/odiagasa.html

Sybase ASA : 

Transactions are started with "BEGIN TRANSACTION [name]". 
Transactions are validated with "COMMIT TRANSACTION [name]". 
Transactions are canceled with "ROLLBACK TRANSACTION [name]". 
Transactions save points can be placed with "SAVEPOINT [name]". 
Sybase ASA supports named and nested transactions. 
By default transactions are started implicitly as in the ANSI specification.
This behavior can be changed with:
   SET TEMPORARY OPTION CHAINED = OFF  

-----Original Message-----
From: Petr ZEMAN [mailto:petrz at aswsyst.cz]
Sent: Thursday, November 24, 2005 9:10 AM
To: freetds at lists.ibiblio.org
Subject: Re: [freetds] begin atomic in procedures


_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list