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 peppler dot org>
Subject: Re: About prepared statements asnd transactions....
Date: Oct 12 2005 5:11AM

On Tue, 2005-10-11 at 19:01 -0400, Edward J. Sabol wrote:
> Yves Orton wrote:
> > The main issue for me is that currently prepared handles +
> > transasctions are dangerous.

>  DBD::Mysql and
> DBD::Pg (for older versions of PostgreSQL only) emulate the capability of
> having multiple active sth's per dbh by reading all the data from an
> unfinished sth into memory when a second sth is executed. I suggested adding
> similar emulation of this capability to DBD::Sybase to Michael in February
> 2004, but nothing came of it, AFAIK.

It's feasible, but it is potentially problematic if the original $sth
has a lot of pending data. I guess it could be an option.

Michael
-- 
Michael Peppler  -  mpeppler@peppler.org  -  http://www.peppler.org/
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html