Other Languages - vertica Database

Hi all..


I need a help on vertica Database.

1)  Is there any facility to declare and assign variables.

2) What is the equivalent keyword in vertica for (exec) in sql server.

3) Can we write a stored procedures in vertica?

4)Can you please suggest steps to write External Procedures in vertica.

Thanks in advance.

Rajasekhar.

Here is a good doc that i found, hope it helps


http://www.vertica.com/wp-content/uploads/2011/01/VerticaDatabaseMultiTerabyte.pdf


Regards

Thanks a lot for your reply.

But i am expecting some clear syntactical information of creating an EXTERNAL PROCEDURE.
Please help me .


Thank you,
Rajasekhar.T