transaction id and transaction isolation - 07-21-2003 , 02:56 AM
Two questions. I am using Sybase ASE 12.5 on Linux.
1. I would like to be able to get hold of the transaction id while
still in the tranasction but I have been unable to find a function
that will return it to me. At the moment I am using the @@spid as the
nearest I could find. Any suggestions?
2. I have a table in my database that I would like one user to be
writing to while another user will be reading from it. The user
reading from the table should only be reading already committed rows -
so that any rows that are being added in user 1's transaction that is
ongoing will not be read by user 2. I have set my isolation level to
read committed with no luck. In SQLServer to achieve this I needed to
set a hint as well - is there something extra I should be setting in
Sybase or will I not be able to achieve this behaviour?