Focal Point
[CLOSED]create synonym from SQL server table-valued functions

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7887081386

July 22, 2016, 03:15 PM
WebFocusDiver
[CLOSED]create synonym from SQL server table-valued functions
Hi,

We have lots of functions built in our SQL server. But I don't see options under "Restrict Object type to" has options of functions like stored procedures. We are trying to see if we can create synonym in Webfocus by linking to table-valued functions instead of Stored Procedures. If not, is there any other way of using these SQL functions inside webfocus?


Thank you

This message has been edited. Last edited by: WebFocusDiver,


WebFOCUS 8.1.05
Windows, All Outputs
July 25, 2016, 08:59 AM
Ricardo Augusto
Hello, what kind of functions?

Show us an example.

Have you tried to access them using SQL passtrough?


WebFOCUS 8.1.05 / APP Studio
August 03, 2016, 11:49 AM
WebFocusDiver
Thanks. The team decide to use SQL stored procedures.


WebFOCUS 8.1.05
Windows, All Outputs