Is there a mechanism by which to designate part of a query expression to not be processed into COGNOS-SQL? I remember there being a setting for "Pass-Through SQL" but in this case there is only one part of a expression that I'd like COGNOS to butt-out on...
Example:
to_char(sysdate, "yyyy")
COGNOS goes about creating a case statement around these:
Case to_char(sysdate, "yyyy") is null then null else to_char(sysdate, "yyyy") yadda yadda
Hope my question is coherent since I am actually asking for someone else...
In the end I supose the question is can you surround the SQL with some kind of escape sequence to get the COGNOS SQL parser to butt-out?
Thanks! ;D
Try wrapping them in curly brackets. {}
Thanks Paul for the response! ;D
We actually discussed {} but I was under the impression he had tried that. I'll post back a status...
{} curly brackets denote Native SQL.
{{}} double curly brackets denote passthrough SQL.
You might want to try with the double brackets.
Regards,
MF.