Up Prev Next
From: Matthew Persico <matthew dot persico at gmail dot com>
Subject: Re: DBD::Sybase 1.05_02 on CPAN
Date: Jul 7 2005 10:27PM
On 7/7/05, Michael Peppler wrote:
> On Thu, 2005-07-07 at 12:11 -0400, Matthew Persico wrote:
> The change *should* be transparent. The only issue that you may see is
> if you are running stored procedures in AutoCommit OFF mode, and the
> procs haven't been set (enabled) for the chained mode (see
> In that case it's a simple matter of executing sp_procxmode to enable
> CHAINED mode for the procedures.
So even if I missed the condition in testing, the production code
would fail, we execut sp_procxmode on the proc and re-run the job.
Is it a bad thing to blanketly sp_procxmode all procs ahead of time?
> Alternatively, build DBD::Sybase with the chained mode default off.
> (still, the chained mode is how AutoCommit is handled with Sybase for
> ODBC and JDBC, so I guess it makes sense to use it here as well.)
Yeah, but since 99.9999% of our coding is Perl, I don't worry about
J/ODBC. I might just build with default off to save myself the hassle.
Matthew O. Persico