sybperl-l Archive

From: michael dot peppler at bnpparibas dot com
Subject: Re: Sybase::CTlib and autocommit
Date: Jun 15 2005 1:32PM

Sybase::CTlib (and the Sybase client libs in general) have no notion of
AutoCommit.
The correct terminology is the CHAINED transaction mode, which is normally
off by default. When the Chained mode is OFF it's the same as AutoCommit ON
for DBI.

See the CS_OPT_CHAINEDTXN option (ct_option()), and the SET CHAINED option
in TransactSQL.

So if you are porting Sybase::CTlib apps to DBI then AutoCommit should be
set to ON.

Michael




Internet
avised@kbcfp.com@peppler.org - 15/06/2005 14:52


Sent by:    owner-sybperl-l@peppler.org

To:    sybperl-l

cc:


Subject:    Sybase::CTlib and autocommit


I'm porting a program from Sybase::CTlib to DBD::Sybase.  Should I set
AutoCommit => 1 for the DBI->connect() call?  In other words, with
Sybase::CTlib is auto-commit on by default?

--
Ed Avis 




This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.