sybperl-l Archive

> 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.