Options
Store results within an User Defined Transform Function into a temorary table
Hello,
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.
0
Comments
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