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"
Stored Procedure Stage error
Moderators: chulett, rschirm, roy
Stored Procedure Stage error
KPSITA