Skip to main content

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

  • March 23, 2015
  • 1 reply
  • 8 views
Tobias_1

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.

    1 reply

    DerrickR
    Forum|alt.badge.img
    • DerrickR
    • Participating Frequently
    • March 23, 2015

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement