Nested Stored Procedure Support in Vertica
We are migrating our product from Sybase IQ to Vertica. We have lot of stored procedures written in Sybase. As Vertica doesn't support stored procedures, we developed few Java UDx which are working as fine.
We are now facing few problems as we are moving forward with migration, lot of our stored procedures are very complex and nested. Nested as in few of the procedure are calling other procedures.
How can we replicate similar functionality using Java UDx? Say there are two Java UDXs, A and B. How exactly B can be called by A? How code reusability is achieved.
One little additional question along with above. There are several types of procedures, few accepting in, out and inout parameters. How can we write such a UDx in Vertica?
Quick response will be highly appreciated.