October 2, 2008 at 5:28 am
Dear pros,
We are using reporting server (sql 2005) on our DB2 database to create some fancy overviews. Now i have a problem with calling a DB2 stored procedure and especially with the output parameter. I cannot figure out how I can get the value of that parameter. I have a stored procedure like library.blabla with two input parameters and one output parameter which is, of course, set in the sp.
I already figured out how to handle a DB2 stored procedure with only input parameters and a result set, but without an output parameter.
This can be done as follows: CALL LIBRARY.BLABLA(?, ?)
Furthermore, I already simulate this using a SQL server sp and it works. I can add this snippet to the query string in my dataset in SSRS. It looks a bit like this:
----------
declare @par2 int
set @par2 = 0
exec pcdTestOutput 1, @par2 OUTPUT
select @par2
----------
But like I said this works for SQL server and not for DB2.
I use the iSeries Access ODBC Driver for the connection.
If you need more information, please let me know.
October 3, 2008 at 7:24 am
I already found out. It is not possible 🙂
We changed the DB2 stored proc that it returns one value and deleted the output parameter. That's easier.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply