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

[blom0344]

You can specify the isolation level on the datasource connection in Cognos admin. There are 6 levels of isolation . The lower the isolation level, the less chance of performing a lock.
However, I am very much simplifying now. You better consult your DBA
[I am wondering if read-only access would ever cause a lock you want to prevent though]