If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Connection Name (not DataSource name)

Started by ej, 07 Apr 2016 09:13:13 AM

Previous topic - Next topic

ej

We are on Cognos 10.2

My goal is for a report to be able to run against either a SQL Server Database or an Oracle Database (btw, table structures are identical).  There is a data field in the package which contains the name of the database that the report is being run against.  Currently, that field is set up in Framework Manager using a SQL Server pass-thru SQL query.  Of course, that query will not work when run against an Oracle database as it contains a specific to SQL Server function. 

I want to, based on the connection (not the data source), have Framework Manager run one or the other query.  I don't know if this is possible.  First I can't find any parameter or means of obtaining the connection name and second, I don't know if one can conditionally run SQL statements within Framework Manager.

Has anyone been able to do this?
Thanks,
EJ