Use SQL WITH Clause

[dwsiva]

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

[MFGF]

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.