The Vertica Database Forums

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

#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..