COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: juffin on 05 Feb 2015 07:03:28 PM

Title: native and pass through sqls
Post by: juffin on 05 Feb 2015 07:03:28 PM
Hi,
There are 3 types of sqls..native,cognos and pass through sql.
Why is it not possible for native sql to access data from more than one data sources?
also what makes pass through sql to access more than one data source?
Any clue members?

Thanks
Juff
Title: Re: native and pass through sqls
Post by: Raghuvir on 06 Feb 2015 01:21:00 AM
Quote from: juffin on 05 Feb 2015 07:03:28 PM
Hi,
There are 3 types of sqls..native,cognos and pass through sql.
Why is it not possible for native sql to access data from more than one data sources?
also what makes pass through sql to access more than one data source?
Any clue members?

Thanks
Juff

Hi,

if you click on the SQL syntax in the property pane, you would get the description of that property on the left bottom of your scrren. Hope that hepls.

Regards