You can translate the question and the replies:

Does Denodo has the command to change the view's cache mode ? eg, from cache "Off" to "Partial", or cache "Off" to "Full"

Does Denodo has the command to change the view's cache mode ? eg, from cache "Off" to "Partial", or cache "Off" to "Full" . Thanks, we need this kind of command for some aotumation tasks. Not want to do it from VDP client.
user
16-08-2020 00:38:14 -0400

1 Answer

Hi, To change the cache mode of a Base view, I would use the "ALTER TABLE" command available in Denodo. For e.g. ALTER TABLE bv_hr_employess cache off More information about this command can be found in the article [Modifying the Base View](https://community.denodo.com/docs/html/browse/latest/vdp/vql/creating_a_base_view/modifying_a_base_view/modifying_a_base_view#modifying-a-base-view). To change the cache mode of a Derived view, I would use the "ALTER VIEW" command available in Denodo. For e.g. ALTER VIEW iv_hr_employess cache full More information about this command can be found in the article [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#modifying-a-derived-view). Hope this helps!
Denodo Team
17-08-2020 01:04:21 -0400
You must sign in to add an answer. If you do not have an account, you can register here