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.