Print Page - Generating full SQL in query subject

Title: Generating full SQL in query subject
Post by: sidney786 on 23 Apr 2014 06:02:38 AM

Hi

I am trying to generate SQL from a query subject, within report studio 10.2

However the sql generated is missing joins possibily being executed at the application layer

I have my FM data source set to limited local.

Is there a way i can view to complete SQL generated by my query?

Thanks

Sid

Title: Re: Generating full SQL in query subject
Post by: bdbits on 23 Apr 2014 05:21:32 PM

If you want to be absolutely certain of what is being generated, it can normally be captured by a DBA on the database side when you run the report.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sidney786 on 23 Apr 2014 06:02:38 AM