MQSeries.net :: View topic - WBIMB Support for SQL Server stored procedures

fel1xs · Posted: Thu Oct 04, 2007 7:44 am Post subject:

Hello
Can someone please claify what support there is within WBIMB V6 for returning data from SQL Server stored procedures?

According to a MSDN article there are four ways that this can be done:

Looking at the WBIMB documentation it clearly supports output params but does it support any of the others (e.g. result sets)? I'm trying to invoke a stored procedure which is returning a result set but I can't seem to be able to access this data. I'm suggesting to the DB developer that he needs to change the Stored Proc to use output parameters.

I've seen an example in the manual as follows:
CALL myProc1() INTO cursor;

but it doesn't specify what 'cursor' is. When I try to save this esql I get this error in the 'Toolkit'
'The called procedure must return a result'

The SP is as follows:
CREATE PROCEDURE [dbo].[usp_GetSchemesReadyForGladis]
AS
SET NOCOUNT ON

SELECT Scennumber
FROM Scenario
WHERE ScenGenerateGladisSchNo <> 0
GO
Thanks Sean