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

Using Command blocks in Cognos datasource

Started by Niranjan81, 22 May 2017 02:59:31 PM

Previous topic - Next topic

Niranjan81

Hi,
I am using Cognos JDBC datasource . Due to the complexity of the queries , I need to pass few database hints as part of the cognos query to the datasource.
Can anyone advise , how to pass STRAIGHT_JOIN from Cognos to the database using the command blocks.
I tried to set by opening a command block, but it did not help.
The query from Cognos should form something like this.
select STRAIGHT_JOIN c1, c2, c3 from t1,t2...

Thanks,
NC

the6campbells



Command blocks can alter session state.

If a vendor allows optimizer settings to be controlled at the session level (as some do) then you might find an appropriate 'set' command.

In your case, your vendor most likely requires that clause placed in-line within a statement.

Hence the answer would be you cannot