i was wondering if there is any way to store the results of an User Defined Tronsform Function directly into a temorary table using the C++ API to avoid another Insert SQL Statement and to encapsulate everything inside the UDx.
Have you tried the INSERT SELECT statement?
You can take any SELECT statement and use it to generate values that are inserted into a table with a matching schema. You can even use "CREATE TABLE AS SELECT" (also known as "CTAS") to have this done automatically.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.