zilanibasha

• Jul 21st, 2006

 

In cognos reportnet

Native SQL is used for the single datasource to import the meta data

Cognos SQL used for multiple datasources to import the metadata

Pavan Reddy

• Oct 19th, 2006

 

Cognos SQL:By default Cognos FWM uses Cognos SQL to create and edit Query Subjects. Contain metadata from multiple Data sources.

Native SQL :But we cannot use Native SQL in a Query subject that references more than one Data source in the Project. Contain metadata from single Data Source.

swift_s

 Profile Answers by swift_s 

• Jun 1st, 2009

 

The Native SQL is what is being passed to the database. Where the Cognos SQL is the entire SQL used to perform the SQL. In certain scenarios, the native SQL will be a subset of the Cognos SQL which may indicate that the application will do some local processing.