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!
OPEN/CLOSE command for sqlserver Stored procedure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Mar 20, 2008 11:55 am
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..
In "Before SQL Tab"
use "SchemaName.StoredProcName"
I think(no sure though) this should work for ODBC stage as well..
Thanks.
"Creativity is the ability to use your available resources to their fullest."
"Creativity is the ability to use your available resources to their fullest."