Pass-through SQL instead of COGNOS-SQL

[flytrap]

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

[CognosPaul]

Try wrapping them in curly brackets. {}

[flytrap]

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

[MFGF]

{} curly brackets denote Native SQL.
{{}} double curly brackets denote passthrough SQL.

You might want to try with the double brackets.

Regards,

MF.