Not getting a result set in SSRS 2008r2 from an iSeries DB2 SQL stored procedure
One thing that you are missing in your stored procedure declaration is the DYNAMIC RESULT SETS option. The default value for that option is 0, may be that's what confuses the client software. Whether it (the client software) can even handle cursors returned by a stored procedure is another story.