Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

About Transaction isolation for Sybase SQLserver 10.0.3

2 posts in Windows NT Last posting was on 1998-03-16 12:49:00.0Z
Golden Ge Posted on 1998-03-16 03:39:17.0Z
From: "Golden Ge" <goldenge@chinasystems-cn.com>
Subject: About Transaction isolation for Sybase SQLserver 10.0.3
Date: Mon, 16 Mar 1998 11:39:17 +0800
Lines: 11
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <plr0NQIU9GA.128@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5115
Article PK: 1092476

Dear All:
I'm not sure that the 'Set transaction isolation level' command
affect to Sybase Sql sever 10.0.3.
Does any one can tell me?


--
Regards
GoldenGe


Eoin Woods (Sybase UK) Posted on 1998-03-16 12:49:00.0Z
Message-ID: <350D1FBC.36DAF755@sybase.com>
Date: Mon, 16 Mar 1998 12:49:00 +0000
From: "Eoin Woods (Sybase UK)" <eoin.woods@sybase.com>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Golden Ge <goldenge@chinasystems-cn.com>
Subject: Re: About Transaction isolation for Sybase SQLserver 10.0.3
References: <plr0NQIU9GA.128@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 20
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5114
Article PK: 1092474


> I'm not sure that the 'Set transaction isolation level' command
> affect to Sybase Sql sever 10.0.3.
> Does any one can tell me?

Well, this is discussed in the Sybase documentation (which is on
the web at http://sybooks.sybase.com/ if you don't have copies).

Briefly, pre System XI, there are two levels 1 and 3. Level 1 is
the default and it means shared locks are released as soon as they
have been used. Level 3 (serialisable) means that shared locks are
held until the end of the transaction to prevent updates while the
transaction is running.

Eoin.
--
Eoin Woods, NT Development, ASE Engineering, Sybase Inc.
Sybase (UK), Crown Lane, Maidenhead, Berkshire, SL6 8QZ
Tel: +44-1628-597215 Fax: +44-1628-597000
Email: Eoin.Woods@sybase.com