Is it possible to use NOLOCK in DB Connect Queries?

[thompsonsgg]

Hello All,

My DBA is requesting that I use NOLOCK in all of my DB Connect queries, but I can't seem to figure out how to do so. Is it possible, and what would the syntax be if so?

Please find an example of the query I am using below.

Thanks,
Annmarie

SELECT DateCreated, DateSent, DateResponseCollected, ResponseCode FROM "Commissions"."disbursements"."HyperWalletFiles"

[BenTan]

Hi,

Not sure if this would work but you could try:

 SELECT DateCreated, DateSent, DateResponseCollected, ResponseCode FROM "Commissions"."disbursements"."HyperWalletFiles" WITH (NOLOCK)

Hope it helps!

Regards,
Ben