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

15.7k Views Asked by At

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

1

There are 1 best solutions below

0
On BEST ANSWER

DB2: Uncomitted Read = WITH UR

SELECT * FROM whatevertable WITH UR