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