Is it possible to exec a Sybase stored procedure and return the result set to a transformer stage. Can't try this at the moment as my data sources haven't been set up. I know that I can return a dataset by executing a sql string but can't find any documentation regarding sybase stored procedures.
If I add a stored procedure stage to a server job then the only database vendor that appears is Oracle.
Sybase stored procedure
Moderators: chulett, rschirm, roy
Hi,
I did it once.
I simply used a user defined sql that run the SP and placed an apropriate table definition.
worked like a charm, I had no issues.
IHTH,
I did it once.
I simply used a user defined sql that run the SP and placed an apropriate table definition.
worked like a charm, I had no issues.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)