sybperl-l Archive

From: Matthew E Studley <matthew at coms dot com>
Subject: Re: dbd::sybase - autocommit and procs creating temp tables
Date: Nov 7 2000 6:51PM

> You have a couple of solutions.
> 
> Assuming you are using Sybase ASE 11.x or later, you can set the
> syb_chained_txn attribute to TRUE. This will allow you to create
> temporary tables while autocommit is off (however, if your app or
> stored procs use transactions internally then this won't work).
> 
> You can set the 'ddl in tran' option to TRUE (see sp_dboption)
> although that *is* a performance issue.
> 
> You can turn ON AutoCommit while you run your proc - that should have
> no negative effect, unless there are pending transactions/operations
> that depend on the results of your stored proc.
> 
> In any case, if your proc is only an analysis proc it makes NO sense
> to run it with AutoCommit off (in my most humble opinion :-)
> 
> Michael


thanks for the help Michael!

regards

matt
_____________________________________________________
Technical Architect		coms.com 
				126-128 New Kings Rd
+44 (0) 7080 810 101		London  SW6 3LZ.