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)**
user
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](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/materialized_tables/inserting_data_into_materialized_tables/inserting_data_into_materialized_tables) and [Temporary tables](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/temporary_tables/creating_temporary_tables/creating_temporary_tables). I would either use **Scheduler** or create a [Remote table](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/remote_tables/managing_remote_tables/managing_remote_tables#managing-remote-tables) 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](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/general_structure_of_a_job#general-structure-of-a-job) and [Exporters](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/developer_api/extensions_plugins/exporters#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