PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Wechsler, Steven M" <WechslerSM at bernstein dot com>
Subject: Strange transaction behavior
Date: May 19 1998 9:46PM

Is there something unusual you need to do in order to be able to use
begin tran/commit tran with DBLib?

Here's what I'm doing:

begin tran
do a bunch of ad-hoc updates to user tables in various databases
do a bunch of updates to system tables via stored procedures
commit tran

This works fine in ISQL.  It also works without the begin tran/commit
tran

However, when I add in the begin tran & commit tran, the ad-hoc updates
don't get applied, and the stored procedure updates get applied whether
or not I commit.

Help is appreciated.

Thanks,

Steve
--
Steven Wechsler/Sybase DBA/Sanford C. Bernstein & Co., Inc.
WechslerSM@bernstein.com 
"Never underestimate the power of human stupidity" - Lazarus Long
Support the Anti-SPAM amendment: http://www.cauce.org