SQL Server Hint

[c8guru]

Does anyone know a way to add a "nolock" hint in Framework manager?  Adding it in the SQL produces an error when validating.  We are using C8 against a transactional system and they want to ensure that the tables aren't locked when queried. 

Thanks,

Steve

[praveennb]

Only option i could find is when a new data source is created, you can choose the Isolation level to READ UNCOMMITED.

hope this helps