SSRS calling SP on Mainframe to access IBM DB2 tables
Does anyone know if you can create a SSRS report, that calls a mainframe Stored Proc?
The stored proc runs a complex query against mainframe DB2 tables, and is parm driven....
June 23rd, 2011 2:32pm
Hi ajm40241,
It seems that you would like to connect to DB2 and use SP in DB2 as a dataset for the report, right? Please correct me if my understanding is wrong.
If that’s the case, please refer to the following article:
Calling a DB2 SP from Reporting Services:
http://blog.hoegaerden.be/2009/04/25/calling-a-db2-sp-from-reporting-services/
For more information about DB2 with Reporting Services, please see the following articles,
Reporting On Data From Stored Procedures :
http://blog.hoegaerden.be/category/sqlserver/reporting-services-sqlserver/page/2/
Data Sources Supported by Reporting Services (SSRS):
http://msdn.microsoft.com/en-us/library/ms159219.aspx
If you have any question, please feel free to ask.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2011 5:25am