Question about Transactions and Locking

Hi,

I’m new to Sybase and I have a question regarding the behavior of transactions. If I have a stored procedure with a transaction where tables (A,B,C,D,E) are updated will it be possible to query table A before the entire transaction has committed without having to wait? After some initial testing under this scenario I’ve not been able to query this table without waiting until stored procedure has completed.

Appreciate any help. Thanks.

Click to visit the source...

#codango #developer #development #coder #coding

We're happy to share this resource that we found. The content displayed on this page is property of it's original author and/or their organization.