[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