SYMPTOM:
Is there a way Strategy can issue a 'NOLOCK' command on a query within Strategy? The SQL below demonstrates an example:
SELECT *
FROM CITY_CTR_SLS WITH (NOLOCK)
CAUSE:
The 'NOLOCK' command is not currently supported in Strategy 10.x.
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.
WORKAROUND:
There is a workaround command, called TRANSACTION ISOLATION, and unlike NOLOCK, it does not need to be set for every SQL line. It can be used as a pre-SQL statement. This workaround will not replace NOLOCK if this command is needed for single table in the SQL.
The following Strategy Knowledge Base technical note explains further details regarding the TRANSACTION ISOLATION command:
KB9873 (KB5200-72X-0421): How to perform a "dirty" read on a database while using Strategy 8.x
KB17563
