You can translate the question and the replies:

Execute a DDL statement in a column in a table

Hello, We have a create table statement stored in a table. Do we have any option in denodo to Execute the query stored in a column one by one. Thanks & Regards, Gokul
user
20-04-2020 06:43:24 -0400
code

4 Answers

Hi, In order to execute a DDL statement in a column of a table, the Denodo Scheduler Administration Tool can be used to input a parameterized query where its data source can be specified. You can have the parameterized query to be @query where then your non-parameterized query can be the select statement query, selecting the column with the DDL statement. This second query says to input whatever @query is defined as. Then you can add a mapping to the column containing the DDL statement. When this created job is run, Scheduler will execute statements against VDP for every result obtained from the non-parameterized query. For more information, please refer to [VDP Extraction Section](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section) document. Hope this helps!
Denodo Team
20-04-2020 16:32:02 -0400
code
Hello, Is there any way where we can do the same thing without the help of Denodo Scheduler Administration Tool. To use something like EXECUTE statement?
user
21-04-2020 05:51:13 -0400
Hello, I will explain this context a bit. We are storing the VQL statements got by calling the procedure "GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW" to a table. Now once the VQLs have been loaded to the table we have to run all the VQL one by one. I need a command which would extract the value from a block and execute it in Denodo. Awaiting your reply.. Thanks, Gokul
user
24-04-2020 07:41:44 -0400
Hi, Yes, you can do the same thing without the help of Denodo Scheduler Administration Tool however then the steps should be done manually rather than automatically with Scheduler. The GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW stored procedure does not create the base view, it only returns the VQL statements necessary to create a JDBC base view for a given table/view of the underlying database of a JDBC data source. Therefore, in order to create the table, you would need to copy the results from the stored procedure and paste it into the VQL shell. Hope this helps!
Denodo Team
30-04-2020 15:00:35 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here