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

vincon

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.

DerrickR

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