Is there an equivalent of NOLOCK table hint of MSSQL in Sybase 15.5 T-SQL?

sybase sap-ase
Anthony Kong picture Anthony Kong · May 16, 2013 · Viewed 9.4k times · Source

I am writing an app that pull data from a sybase table rather frequently. Since I will not write any data back to the database, I want to increase the read performance by not holding data locks on the target table.

In MSSQL I can do it via table hint NOLOCK. Is there a equivalent in the Sybase T-SQL?

Answer

Michael Gardner picture Michael Gardner · May 17, 2013

First, let me say that it's not recommended to use NOLOCK.

I believe the locking hint you are looking for is noholdlock or at isolation, but the syntax varies depending on if you are trying to use it at the session level, the query level, or for specific tables within a query.

The full explanation can be found here in the Locking and Concurrency Control documents from Sybase.

Related questions

From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.

Read More
list all tables from a database in syBase

In sql server 2012 i'm using USE myDatabase; GO SELECT * FROM sys.objects WHERE type = 'U'; Is it possible to do the same in syBase ?

Read More
How do I look at column metadata in Sybase?

I have a list of columns a co-worker has given to me, but these columns reside in different tables in the DB. Is there some kind of tool in Sybase where I can query the table a column belongs to? (…

Read More