You can translate the question and the replies:

Default Setting: Drop Elements vs Replace Elements

In Denodo 7, when opening VQL file or exporting VQL, the default setting was to "Replace Existing Elements." However, in Denodo 8, in Design Studio, when opening VQL or exporting VQL, the default option for generating code is to "Drop Elements before creating them." This has created some confusion on the developer side as they open a base view, forget to change the setting to "Replace...", and execute DROP CASCADE script. If this is for a base view, it will drop all dependent views which are not always included in the VQL script. DROP DATASOURCE JDBC IF EXISTS sql_db **CASCADE** Where can I find the default setting for Drop Elements vs Replace Elements? In order, the setting for opening a VQL file is most important, but also exporting VQL as well. Thanks!
user
19-05-2023 13:43:07 -0400
code

3 Answers

Greetings , Hope you are doing well. Assuming Denodo 8 is used, if you went to the [export dialog](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/exporting_and_importing_the_server_metadata/exporting_the_server_metadata/exporting_the_server_metadata#export-dialog) in VDP admin tool or Denodo Design studio (File > Export or Export Database), then by default the option “Replace Existing elements” is pre-selected. However, if you are using the [Export script](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/export_script), you could control such options using the [dropElements](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/export_script#:~:text=p_customer%20AS%20SELECT%20%E2%80%A6-,dropElements,-If%20yes%2C%20the) and [replaceExistingElements](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/export_script#:~:text=replaceExistingElements) properties. These could be passed easily in the script using the following syntax: <property name> = {yes | no}. Hope this helps !
Denodo Team
24-05-2023 02:32:10 -0400
code
Hi Denodo Team, thank you for the initial response. *Assuming Denodo 8 is used, if you went to the export dialog in VDP admin tool or Denodo Design studio (File > Export or Export Database), then by default the option “Replace Existing elements” is pre-selected.* Confirmed that this functionality works as expected. However, as stated in the original question, in Design Studio, when double-clicking an object, selecting VQL, the default SQL format selected is "Drop existing elements before creating them." Please advise how we can make this functionality match in Design Studio, same as in VDP Tool. Thanks!
user
24-05-2023 13:47:29 -0400
Greetings , Hope you are doing well. In Design studio, once you double click an object, selecting the export button invokes the export dialog and this has your desired choice as default option (i.e., “Replace Existing Elements”). In addition to, export options stated above (e.g., Export dialog , export script, VDP admin tool …etc.). It is only when the object is opened via Design studio, and the VQL tab is selected the “Drop elements before creation” is pre-selected. However, I recommend raising this request as a product enhancement in the [support site](https://support.denodo.com/MainPage.do) while describing the expected benefits. Hope this helps!
Denodo Team
29-05-2023 04:18:41 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here