External procedure
I've been reading the Vertica 10.1 manual about external procedures, but I'm confused, normally from Javascript we used the SP on SQL Server to search tables passing the parameters to the SP and getting the response to put it on our web app, but frankly I don't know if we can use external procedures to do the same, maybe we've to wait to the release of Vertica 11. Please anyone has do this with the external procedure on Vertica? ideas? Thx!
Best regards.
Frank
Best Answer
-
Bryan_H Vertica Employee Administrator
Hi, Vertica 11 is generally available with support for stored procedures written in PL-pgSQL. Please see our documentation here:
https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/ExtendingVertica/StoredProcedures/StoredProcedures.htm
It's possible to write an external procedure, which is a script loaded onto Vertica servers to execute SQL scripts, but you may find the new PL-pgSQL stored procedure support to be much more familiar. If you have a current license or support account, you should contact your representative for technical advice on the different options.0