Stored Procedure stage: New columns not returned

FranklinE · Post by **FranklinE** » Tue Jul 05, 2011 7:55 am

I and the person for whom I'm asking this are new to SP stages in general, this being an "inherited" job that needs enhancement. We are open to the possibility that this is a problem on the DB2 side, though it doesn't look that way so far.

Existing SP was in use with no problems. Two columns were added to one DB2 table served by the SP. The SP stage and following links were modified to include the new columns, but they come back empty in the return set. The query has been verified using SPUFI, and the columns do have data in them that should be in the return set.

Finally, the Director log shows nothing of consequence in Warning messages, and the job completes normally. Thanks.

FranklinE · Post by **FranklinE** » Tue Jul 05, 2011 9:54 am

As can often be the case, it was (developer) user error that created the problem.

It turns out that there were more than two new columns added to the DB2 table, and the SP parameters had to have places for them in the call and return set. Adding those columns to the output schema did the trick.