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
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