Q&A

Script to turn Cache on or off
answered 20-08-2020 02:06:09 -0400

Is there a VQL script to turn on or off the cache so that instead of navigating to Administration>Server Configuration and switching the Cache, I can just run the script in VQL shell to get this done. Thanks and regards.

Answers: 5

DENODO Virtual DataPort

Compound data type error
answered 20-08-2020 01:55:38 -0400

I am trying to create an array data type, I tried the following syntax shared in the below link https://community.denodo.com/docs/html/browse/7.0/vdp/vql/defining_other_elements_of_the_catalog/defining_a_data_type/defining_a_data_type#defining-a-data-...

Answers: 3

ARRAY Compound Types

like vs contains
answered 19-08-2020 07:27:11 -0400

What's the different between like and contains under simple condition when create selection view?

Answers: 3

VQL simple condition

how to export data from denodo web service into an excel ?
answered 19-08-2020 05:12:09 -0400

how to export data from denodo web service into an excel ?

Answers: 1

What is the maximum value that can be searched in an obligatory field with multiplicity 1
answered 19-08-2020 02:27:58 -0400

Hi, I have created a base view with one field as Obligatory and i am able to search multiple values in the webservice using ISCONTAINED in the same field. is there any maximum number that can be search ? and why i am not able to set multiplicity as an...

Answers: 1

denodo vs Teiid
answered 18-08-2020 16:45:20 -0400

what is the difference between them?

Answers: 1

long time, even seems dead when VCS pull
answered 18-08-2020 09:45:51 -0400

Hi team, want to understand, why VCS pull needs so long time? We have some requriement that needs to change the VCS branch name and then do a re-pull, when this happended, we found all objects (totally 2000+) needs to do a re-pull, and this process ta...

Answers: 6

much long time VCS pull

How to do the cache load for a view
answered 18-08-2020 08:50:38 -0400

How to load cache load for a view, we have kinds of cacje mode, full, partial, waht is the exact command? do we have artical to introduce it? Thank you.

Answers: 1

vql cache data preload

Need help creating a Base View from a SQL Server Stored Procedure
answered 18-08-2020 08:14:29 -0400

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Answers: 3

Base view Create Base View Stored Procedure SQL Server

How to Executing VQL statements from Custom Policy
answered 18-08-2020 07:15:43 -0400

How to Executing VQL statements(SQL command) from Custom Policy. Because customer access policy data is store in database table.

Answers: 1