Calling DB2 Stored Procedure with outer.row as parameter

<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif I have a unique problem. Using the report designer, I need to create a data set that retrieves data using an existing DB2 stored procedure. The problem is that the input parameter for this stored procedure needs to come from a cell in an outer table. 
 
Here is the scenario: 
 
I have user ID's in a db2 table that I have in a dataset. this dataset is bound to a table. Inside this table, I need to place another table that will be bound to a dataset created from a stored procedure. 
 
So, for each user ID, I need to retrieve the user's name from the stored procedure using the user id as the input parameter. 
 
I have no idea how to do this. I am new to using stored procedures in BIRT. 
 
Can anyone please help?

Find more posts tagged with

Comments

Toadly

Hi,
I need to do something very similar, did you ever find an answer?

thanks in advance
Tony