How to allow SQL hints

[dferrara]

I would like to make it so that Cognos does not allow Locking on tables when reading. The data is not real time so it is not an issue. I tried to add  with (NoLock) to the query item in FM but received a syntax error. Any thoughts?

[jive]

Hi Daffy,

Can you tell what is the Database you use. Depending of the database you can customize the date source connection and add command, may be it's the place where you have to set that.

Regards
Jacques