Technote (troubleshooting)
Problem(Abstract)
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 subject2. 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
1021539
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.