Store results within an User Defined Transform Function into a temorary table



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.


  • Options

    Hello, Vincon.


    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.


    - Derrick

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file