Any Tools are available for Migrate Store procs from Sybase IQ to Vertica...?

Mars_1

Sybase IQ to  Vertica Migration 

Jim_Krieger

Vertica does not support stored procedures.  My understanding is there is no plans to add this.

Vertica supports the following extensions to replace some capabilities of stored procedures    http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/ConceptsGuide/Other/ExtendingHPVertica.htm...

• User-Defined SQL Functions let you define a function using HP Vertica SQL statements.
• User Defined Extensions and User Defined Functions are high-performance extensions to HP Vertica's capabilities you develop using the HP Vertica Software Development Kit (SDK).
• External Procedures let you pipe data from HP Vertica through external programs or shell scripts to perform some form of processing on it.

We created our own user defined functions and wrote some of the code in our java application
 http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATEFUNCTI...

Mars_1

Thanks for your info Jim

Jim , I have small store proc   in sybase  that is just table creation. How can I create the same in vertica..?

which one is (1- Write a sql 
2- Write a external procedure 3- UDF) the best way to migrate the store procedure  in Vertica..?