You can translate the question and the replies:

Refresh of DF wrapper base view loses NULLVALUE inline constraint

We are utilizing 7.0.20181011. We have a pipe delimited file source utilizing the DF wrapper. We have added the NULLVALUE constraint to the columns of the base view via VQL. It works great but every time the base view is refreshed, we lose the NULLVALUE constraint and have to reapply it via VQL. Is there a way to get that constraint to stay in place with a refresh? thanks!
user
24-07-2019 16:43:25 -0400

1 Answer

Hi, This is the expected behaviour from Denodo Platform. Whenever Source refresh is done, the wrapper will be updated with the underlying data source configuration. For your case, I would re-create or alter the wrapper output schema with NULL VALUE inline constraint property by executing the below command from the VQL shell: ``` ALTER WRAPPER DF <name:identifier> DATASOURCENAME=<name:identifier> OUTPUTSCHEMA ( field1 = 'field1' (OPT) NULLVALUE '', field2 = 'field2' (OPT) ); ``` For more information, you could refer to section, [DF Wrappers](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/generating_wrappers_and_data_sources/creating_wrappers/df_wrappers#df-wrappers) of Virtual DataPort VQL Guide Hope this helps!
Denodo Team
29-07-2019 07:28:26 -0400
You must sign in to add an answer. If you do not have an account, you can register here