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

Combining Stored Procedure and SQL together in Report Studio

Started by 84gopi, 25 Sep 2015 04:24:01 AM

Previous topic - Next topic

84gopi

Hi,

Can any one tell me how can we combine Stored Procedure and SQL statement together in Cognos Report Studio 10.2.

Currently I have SQL script in report ,which is taken direct from SQL server database source and it is working fine.

Now need to add one update Stored Procedure to this SQL, before SQL script run data it has to update this procedure and run.

Any help urgent is much Appreciated here.

Thanks
Gopi