SQL Server Performance Forum – Threads Archive

Calling DB2 procedure

We are facing problems while creation reports from SSRS working with DB2 as a database. Stored procedures defined on DB2 returns data to Reports.
We have tried to call DB2 stored procedure from Report Designer in following ways 1. Call the DB2 Stored Procedure from Report Designer with command type as Text
{ CALL SG4OPROC.P8G4ARTO(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) } â€“ This works at design time but we are not able to pass parameters to stored procedure at runtime from report. If we call the Stored Procedure with the same way as SQL Server i.e. appending parameters with ‘@’ symbol, the query is not parsed by DB2 for execution. 2. Call the DB2 SP from Report Designer as command type as Stored Procedure
SG4OPROC.P8G4ARTO â€“ The out put parameters from Stored Procedure are not identified by the report and gives error that Stored Procedure is not found. Thanks for any pointers

This not a soution, but have you tried asking the same in DB2 related forums, may check IBM for relvant information. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks sathya. But I can’t get you clearly when you say ‘This is not a solution’. I strongly feel that we have to figure out in SS RS to see how to call a DB2 stored procedure from SS RS instead of asking IBM. Take a sample case where a 3rd party is providing reporing services to sql server.
If that reporting service does not work properly in calling a sql server stored procedure, we cannot ask Microsoft about it. In the same scenario we cannot ask IBM, how to invoke db2 procedure from SQL Server
Reporting services. Correct me if I am wrong.

I mean to say my post is not a solution… but a suggestion [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. Right too many are involved here, then try to ask vendor to fix the problem, out of interest searched on google returned below links about db2: http://www.devx.com/IBMDB2/Article/27818</a> http://www.dbazine.com/db2/db2-mfarticles/lawson1</a> http://www.mcse.ms/archive94-2004-8-1009406.html</a> HTH <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

]]>