Since stored procedure is not supported by vertica, so what's the alternative to handle it?

abhishek_1

[Deleted User]

Hi, Depending of what do you do in the store procedure you could , 1- Write a sql 2- Write a external procedure 3- Write a Udf or Udx. The documentation explains number 2 and 3. Hope this helps, Eugenia

Prasanta_Pal

Hi, In Vertica the STORED PROC is a bit different concept than other databases. Vertica creates the STORED PROC ( CREATE PROCEDURE ...) as an object in database but the code behind is a .sh file ( shell script) which is invoked when you run the STORED PROC from database. For details, see the documentation.

abhishek_1

Thanks a lot for the support !!!!

Prateek_Goyal

Hi I have the same doubt, can you please share the document. mail id : prateekgoyal1189@gmail.com thanks in advance Regards, Prateek

[Deleted User]

Hi Prateek, The documentation is posted online here: http://www.vertica.com/documentation/documentation-6-1/ You might specifically want some of the following pages: (linked to from the main documentation page above) https://my.vertica.com/docs/6.1.x/HTML/index.htm#13587.htm https://my.vertica.com/docs/6.1.x/HTML/index.htm#15713.htm https://my.vertica.com/docs/6.1.x/SDK/html/index.htm Adam

mario_lacroix_7

In case of a 3-tier programming structure, where the DB layer is usually based on top of Stored Procedures to be run as functions. How is the recommend approach? 

Mars_1

Can u give  small example .. How to create the store proc  in Vertica