DSXchange

Im currently using an ODBC stage to connect to a sql server database.
I need to execute a stored procedure in the same stage.
I tried the OPEN/CLOSE command offered in the ODBC stage and getting errors like.
[IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]ILLEGAL SYMBOL 'CALL "SP_LOAD"'; VALID SYMBOLS ARE ( END GET SET CALL DROP FREE HOLD LOCK.

I tried the below synatax -
'EXECUTE SP_LOAD'
'EXECUTE "SP_LOAD"'
'CALL SP_LOAD'
'CALL "SP_LOAD".

None of them seem to be working.
pl. help! thanks!

I used RDBMS stage and used "before SQL" tab and mentioned just the stored procedure name without call/execute or any other command.

In "Before SQL Tab"
use "SchemaName.StoredProcName"

I think(no sure though) this should work for ODBC stage as well..