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: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Strange transaction behavior
Date: May 19 1998 10:10PM

Wechsler, Steven M writes:
 > 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

If it works in isql it should work with Sybase::DBlib. I suspect that
you are not processing the results correctly (ie you are maybe not
calling dbresults() until it returns NO_MORE_RESULTS each and every
time).

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com