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

问题:

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:

DB2: Uncomitted Read = WITH UR

SELECT * FROM whatevertable WITH UR