Originally posted by: SystemAdmin
I created a testing stored procedure with one input/output parameter that just returns the row count from a table.
CREATE PROCEDURE s_SQLTest
@Return int OUTPUT
AS
SELECT @RETURN = count(*) from subenroll
When i execute this procedure from a Sink Ouput card as follows
DBQUERY("CALL s_SQLTest(?/'0')", "...")
I get a error in my trace file stating the following.
<2788-2100>: Query : CALL s_SQLTest(?/'0')
<2788-2100>: The procedure statement to be executed is:
<2788-2100>: {call s_SQLTest()}
<2788-2100>: OLE DB Error code: 0x80040e10
<2788-2100>: Procedure 's_SQLTest' expects parameter '@Return', which was not supplied.
I have tried changing the syntax to each of the following and i still get the same error.
DBQUERY("CALL s_SQLTest(?/0)", "...")
DBLOOKUP("CALL s_SQLTest(?/'0')", "...")
DBLOOKUP("CALL s_SQLTest(?/0)", "...")
Can someone help me with this syntax. I've looked at the documentation and i don't see anything wrong with it. I'm running this from a output sink card.
#DataExchange#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender