Stored Procedure Transaction Control 
Author Message
 Stored Procedure Transaction Control

Hello,

  Is it possible to execute a stored procedure which performs updates
and then returns successfully, but does not commit the transaction until
a later call to Sybase???



Thu, 02 Mar 2000 03:00:00 GMT
 Stored Procedure Transaction Control

Yes.  Do a Begin Tran before you execute the stored proc in question,
and a commit after it returns.  Can be done from a GUI front end, or
from another stored proc, or from batch SQL.

HTH.

Billie Patterson

--
Remove the antispam "_AT_" from my e-mail address to reply directly.

Quote:

> Hello,

>   Is it possible to execute a stored procedure which performs updates
> and then returns successfully, but does not commit the transaction until
> a later call to Sybase???



Fri, 03 Mar 2000 03:00:00 GMT
 Stored Procedure Transaction Control


Quote:
>Hello,
>  Is it possible to execute a stored procedure which performs updates
>and then returns successfully, but does not commit the transaction until
>a later call to Sybase???

Scott,

One possible way to do is to execute a "begin transaction" in the same
persistant conneciton before you call the stored procedure.

Once you get the return and are happy with the results, you can
execute a "commit transaction" in the same persistant connection.

I hope its clear that the connection must be persistant(can not log in
and then out)

TonyB
--
Tony Basoglu




Fri, 03 Mar 2000 03:00:00 GMT
 Stored Procedure Transaction Control

Quote:

>   Is it possible to execute a stored procedure which performs updates
> and then returns successfully, but does not commit the transaction until
> a later call to Sybase???

        Do you mean to leave a transaction open? In the same stupid way
        PowerBlunder does it by default?

-am



Sun, 05 Mar 2000 03:00:00 GMT
 Stored Procedure Transaction Control

Yes, but we avoid not closing a transaction in the same batch in which
it was opened.  

We have several stored procedures which contain transactions that we
wanted committed as a group or not at all.  The way we did it was by
performing a begin tran or save tran or commit trans based on the value


Send me an email if you need more info.



Sun, 05 Mar 2000 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Transaction control between v b and stored procedure

2. Calling a Java Stored Procedure from another Java Stored Stored Procedure

3. Source control on stored procedures?

4. Stored Procedure Change Control

5. Stored procedures and version control

6. VB - Using A Parameterized Stored Procedure As A RecordSource For A ADO Control

7. Stored Procedures Under Source Control with SQL Server 2000

8. Source Code Control for stored procedures

9. Using internet transfer control in a stored procedure to capture web page text

10. Store procedure: how to reference to a control on access form

11. Stored Procedures and Version Control

12. SQL 7 Version Control of Stored Procedures


 
Powered by phpBB® Forum Software