05-18-2012 11:28 AM
What sort of destinations can the Stored Process Web Application (SPWA) support?
It looks to me like the SPWA can only receive STREAMING results from a stored process, but not package results. Is that right?
SPWA is happy invoking a stored process that sets _odsdest=html | rtf | pdf, but I can't have _odsdest=SASREPORT (or maybe I could use _odsdest=SASREPORT if I set the appropriate Content_type ?)
If this is correct, the main implication of this is that the SPWA cannot return results from a stored process running on the workspace server, because the workspace server returns only package results (unless you get tricky like Don Henderon suggeSts in : http://hcsbi.blogspot.com/2011/05/put-statements-in-workspace-server-to.html).