Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

Columns
answered 17-05-2017 08:54:24 -0400

how do I delclare a column as null or not null in denodo ? is this even possible ? If it is what is the syntax ?

Answers: 1

NULL and NOT NULL
answered 17-05-2017 08:34:11 -0400

how do I delclare a column as null or not null in denodo ? is this even possible ? If it is what is the syntax ?

Answers: 1

intellisense not workin
answered 16-05-2017 13:22:38 -0400

Hi, I am new to Denodo and was wondering how intellisense functionality works on Denodo. When writing case statement, the intellisense comes up and once I select the statement and go on to fill in the logic for columns, there is no intellisense. Do I h...

Answers: 2

DENODO

CACHE, MATERIALIZED TABLES
answered 16-05-2017 08:28:07 -0400

1.To turn on the cache on the database I know I can use the following steps. Administration>Database Management>select your database>Set Cache status to “On”. However I need to use the feature using the VQL shell. How would I go about doing th...

Answers: 1

Licence key for denode express 5.5
answered 16-05-2017 05:16:33 -0400

Is there a licence key for denode express 5.5 for this year? For now we don't have the time to upgrade to 6.0. And the licence key for now experid yesterday

Answers: 1

Denodo Testing Tool Tests in Jenkins
answered 15-05-2017 09:36:02 -0400

Is it possible to automate tests built for the Denodo Testing Tool in Jenkins?

Answers: 1

Denodo Testing Tool

Create Datasource SQL with servername that has a backslash
answered 15-05-2017 03:32:48 -0400

How can i create a SQL 2012/2014 JDBC connection with a serverbname that has backslash in it. Example: ( jdbc:jtds:sqlserver://emilbras\emilbras:1433/emils_archive;useNTLMv2=true;domain=emilbras) Thanks for the replay

Answers: 2

How to recover Invalidated cache?
answered 12-05-2017 08:57:07 -0400

I have fully invalidated the cache for a derived view and saw for all views in my project, cache got invalidated and no data comes from Cache. Now I want to reload the cache and always want to fetch data from cache db with full cache mode. Please let m...

Answers: 1

I asked a question earlier about creating physical tables in denodo and was told that materialized tables is the answer ! I want to know how you would implement the code below as a materialized table in denodo as currently it isn't working !
answered 12-05-2017 07:33:28 -0400

CREATE TABLE TESTTABLE1 ("C0" VARCHAR(4), "C1" NUMERIC(3, 0), "C2" NUMERIC(3, 0), "C3" NUMERIC(3, 0), "C4" NUMERIC(12, 3), "C5" BOOLEAN, "C6" BLOB, "C7" TIMESTAMP) select * from TESTTABLE1 [Error] Script lines: 8-8 -------------------------- Error...

Answers: 1

How can I create a physical Table on Denodo ? Is it even possible ?
answered 11-05-2017 14:55:21 -0400

denodo version 6.0. I need to do it using your vql syntax and not your user interface. If you let me know how it can be implemented so we can suport denodo users on our software.

Answers: 1