Hi All,
I am new to vertica and got to know that there is no support for stored procedures in vertica and instead we can create external procedures and add it to vertica.
Please provide me a step by step instructions for how to create an external script and add it to vertica.
My requirement is to select all records from an employee table where empid is some value and empid is passed as an parameter.
So how to create a script for this and add it to vertica.
I need to know
1. How to create the the external script
2. Add the script/procedure to vertica
3. How to call the procedure in vertica so that i will get the desired output.
Thanks in Advance
Sushanth.B
Creating external procedures
Moderator: NorbertKrupa
Re: Creating external procedures
#Sushanth
You can refer to this link
https://my.vertica.com/docs/6.1.x/HTML/ ... #13587.htm
Also, You can refer to this example on forums
viewtopic.php?f=63&t=1329&p=4316&hilit= ... dure#p4316
Hope this helps..
You can refer to this link
https://my.vertica.com/docs/6.1.x/HTML/ ... #13587.htm
Also, You can refer to this example on forums
viewtopic.php?f=63&t=1329&p=4316&hilit= ... dure#p4316
Hope this helps..