You can translate the question and the replies:

VQL Required to add a data movement plan using Alter?

What is the VQL required to Alter a data movement plan? Here is the context from the CREATE statement: CREATE OR REPLACE VIEW sv_basespace_rundata as field1 field2 field3 CONTEXT (DATAMOVEMENTPLAN = iv_getsession_roles : JDBC datasources."ds_BaseSpace" iv_getsession_roles_array : JDBC datasources."ds_BaseSpace" datasources.bv_basespace_workgroupilist : JDBC datasources."ds_BaseSpace"); I see the docymentaiton [here](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/defining_a_derived_view/modifying_a_derived_view/modifying_a_derived_view), but I can't turn that into a working alter staement? This is required for modifying the views on different server.
user
31-03-2020 16:13:52 -0400

1 Answer

Hi, The example in the document that you referred to is suggesting a case with multiple plans. You have a valid create statement but the syntax of the alter statement varies with the number of your movement plans. For example if your VQL has only 1 plan, then there is no need for the extra empty parenthesis in front of the view name as shown below: ALTER VIEW test DATAMOVEMENTPLAN = { internet_inc: (JDBC ds1) } As addressed in the [Modifying a Derived View](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/defining_a_derived_view/modifying_a_derived_view/modifying_a_derived_view) documentation, if one of the subviews has several data movement plans and you want to leave some of them unchanged, then you should leave the parenthesis empty. Hope this helps!
Denodo Team
01-04-2020 15:37:11 -0400
You must sign in to add an answer. If you do not have an account, you can register here