MS SQL Server 2008 “with (nolock)” equivalent for

Question

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 1

DB2: Uncomitted Read = WITH UR

SELECT * FROM whatevertable WITH UR