How to see Native SQL in Framework Manager?

Technote (troubleshooting)


How to see the native SQL or Cognos SQL in Framework Manager?

Resolving the problem

Edit the definition of a query subject. Test for the results. The SQL will be generated in the "Results Information" tab.

If the "Results Information" tab is blank, you'll need to edit the "Level of information shown in the Results Information" by using the slider in Options.

Steps:1. edit the definition of a query subject

2. click "test" to return data in the test results window

3. click on "Results Information" to view the Cognos SQL and the native SQL.

4. if the window is blank, click on Options in the Query Subject window.

5. move the slider for "Level of information shown in Results Information" to the right for more detail.

Historical Number


Document information

More support for:

Cognos ReportNet

Software version:

Cognos ReportNet 1.1MR2, Cognos ReportNet 1.1MR3

Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation