You can translate the question and the replies:

Hi, I want to update a table on a join condition with another table or can we set a value coming from a select query in the update statement?

26-02-2021 07:59:58 -0500

1 Answer

Hi, For this scenario, I would use a Scheduler job to run an **[UPDATE](** statement using the values retrieved from the SELECT clause (Join Query). You could follow the below mentioned steps: * In the Virtual DataPort Administration Tool, **[create a data source](** to establish a connection to the source and then **[create base views](** from it. * Then, in the Scheduler Administration Tool, **[configure a VDP data source](** to connect to the Virtual DataPort. * You could then [**create a VDP job**]( and navigate to the **[Extraction](** section to specify the update and select queries. **For instance: ** In the **[Parameterized query](** specify the UPDATE statement like **UPDATE <baseview1> SET column1 = @param_field1, column2 = @param_field2...., columnN = @param_fieldN WHERE [condition]** In the **[Non-Parameterized Query](** specify the SELECT statement like **SELECT field1, field2...., fieldN FROM <baseview1>JOIN <baseview2> ON [condition] WHERE [condition]** For more information, you can take a look at the **[Creating and Scheduling Jobs](** section of the Scheduler Administration Guide. Hope this helps!
Denodo Team
02-03-2021 01:11:54 -0500
You must sign in to add an answer. If you do not have an account, you can register here