Stored Procedure

wizee · Post by **wizee** » Sun Sep 14, 2008 8:14 am

I have a stored procedure which outputs two result sets.

Result set #1
col1 col2 col3
1 b test

Result set #2
col4 col5 col6
34 abcd 122

My first job is designed to get the Result set#1 and second job to get Result set#2.My problem is I get the results from Result set#1 in my second job also. I have checked the parameters, input/output columns and everything is according to Result set #2. Where am I not looking?Any suggestions??

shaimil · Post by **shaimil** » Mon Sep 15, 2008 1:59 am

Can you specify the calls you're making in this post together with any arguments.

wizee · Post by **wizee** » Mon Sep 15, 2008 4:39 pm

This DB2 stored procedure gives correct output when I test it outside datastage. Is there something I need to set up for a stored procedure stage within datastage to view both the outputs?