Up Prev Next
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 :-)
thanks for the help Michael!
Technical Architect coms.com
126-128 New Kings Rd
+44 (0) 7080 810 101 London SW6 3LZ.