Search code examples
sybaseisolation-levelfreetdsunixodbcrowlocking

Unix FreeTDS Isolation Level Sybase

According to the Sybase Documentation (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbusage/udtisol.html) there is one paragraph:

[...] The default isolation level is 0, except for [...] and TDS connections, which have a default isolation level of 1. [...]

Im connecting to that server using FreeTDS on Unix. Till now I haven't found a solution to change the Isolation-Level to 0 (Read-Uncommitted) (maybe using /etc/freetds.conf but here I also haven't found anything). For me its not possible to modify SQL-Statements so I'm looking for a config-option.

Anyone an idea?

Solution

  • That does the trick:

    set TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;