Hi All
In Query Explorer,Properties pane,we have the option called "Use SQL WITH clause".
Can anybody tell me what is the use of this option?
Thanks in advance to all
Hi,
Take a look at the latest SQL99 standard for a description of the "with" syntax (an alternative to "select"). Earlier standards (89,92 etc) do not support "with" so any Cognos query using this syntax will get converted back to a "select" in the native SQL for databases that are not SQL99 compliant.
MF.