Stored Procedure Stage error

[kpsita]

Hi,

I have a stored procedure in Sql Server and I wanted to execute this stored procedure using Datastage. This SP doesn't have any parameters.

First I tried to execute this SP using just a stored procedure stage and then I tried to execute it using a Row generator stage before executing the stored procedure stge. But in both these cases I am geting the following error. Can anyone help me please

Error occurred during initializeFromArgs().
Stored_Procedure_7: When processing argument -stagepropsWhen processing stage property list: {
DBVENDOR='MSSQL Server',
DATASRC='datasource',
USERID='user',
PASSWORD='password STDPROC='SP',
GENSTD='Yes',
TYPEPROC='Transform',
PROCSTMT='{ ? = CALL SP( ? ) }',
SPPARAM='ReturnValue-+-param-+-?-+-I',
TX_ISO_LEVEL='None',
TRANSMODE='ANSI',
CLIENTCHARSET='Default',
DBPROCTYPE='Stored procedure'
} is not a valid property list: Expected "," or "}", got: "SP"

[chulett]

I don't believe that the Stored Procedure stage supports procedures without at least one parameter. Probably more appropriate to use an ODBC stage for that.

[kpsita]

Thank you

[asorrell]

I'm going to post to this even though it shows "resolved"...


You can run a procedure without any parameters, you just have to set the STP stage to type "Source" and it will execute without parameters and send back a return code.

[bgs_vb]

You can call the Stored Procedure in the after SQl of the target DRS Stage.