You can translate the question and the replies:

Denodo Inserts with dynamic values

Is it possible to insert records in denodo base views with the below query **insert into base_view1 (col1,col2) select col1,col2 from base_view2;** With the current doc I concur we can only insert hard coded values like below **insert into base_view1 (col1,col2) values ('name',1)**
19-02-2020 05:33:33 -0500

1 Answer

Hi Currently in Denodo Platform INSERT INTO SELECT statements are supported only for populating [Materialized tables]( and [Temporary tables]( I would either use **Scheduler** or create a [Remote table]( to insert the data. In case of using Scheduler, I would follow the steps in the Scheduler Administration Tool, * Create a job with a select statement for instance > SELECT col1,col2 from base_view2 * Define a new JDBC exporter in the exporter section of the job and use the view where you have to insert the data for instance ‘base_view1’ For more information, you can have a look at the sections [General Structure of a Job]( and [Exporters]( of the Scheduler Administration Guide. Hope this helps!
Denodo Team
20-02-2020 07:25:32 -0500
You must sign in to add an answer. If you do not have an account, you can register here