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

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

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