MS SQL Server 2008 "with (nolock)" equivalent for IBM DB2 9.7

sql-server db2 nolock
user1340582 picture user1340582 · Oct 28, 2013 · Viewed 12.7k times · Source

In MS SQL Server 2008 you can write like this:

FROM EMPLOYEE as A with (nolock)

Is there an equivalent syntax for DB2 9.7? Thanks

Answer

OzrenTkalcecKrznaric picture OzrenTkalcecKrznaric · Oct 28, 2013

DB2: Uncomitted Read = WITH UR

SELECT * FROM whatevertable WITH UR

Related questions

Relationship between catalog, schema, user, and database instance

To compare databases of different vendors (Oracle, SQL Server, DB2, MySQL, and PostgreSQL) how can I identify any object uniquely and do I need a catalog? For instance, In Java's DatabaseMetadata I should specify catalog and schema fooPattern at least. …

Read More
Query validation using C#

I am looking for a query validator in C#, which allows me to parse the SQL text from a textbox and verify whether it's correct or not before sending it for execution (MS SQL or DB2 queries).

Read More
What does a timestamp in T-Sql mean in C#?

I'm trying to develop a model object to hold a Sql Server row, and I understand perfectly how to do this except for the T-Sql/SqlServer timestamp. The table is defined as: CREATE TABLE activity ( activity_id int , ip_address …

Read More