What does this error mean in query studio:
An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'
It means that an error has occurred of which you know nothing about and you have to google the internet for 17937836364484944040 trillion errors to find a clue as to what is exactly happening.
There might be something else written with that error which might be worth exploring.
lol cognostechie... actually I get 792 hits from google. :D
http://lmgtfy.com/?q=cognos+query+studio+%27sqlpreparewithoptions%27+status%3D%27-120%27 (http://lmgtfy.com/?q=cognos+query+studio+%27sqlpreparewithoptions%27+status%3D%27-120%27)
But he is right, trojnfn, need more info please. It might also be relevant to know what database you are using, if you are using a DMR (dimensional) package, type of query, did it work before or this is brand new, etc.