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

SOURCE_CHANGES() error out with following error: The following fields are obligatory: table_name
asked 15-02-2019 13:57:54 -0500

Hi Team, I am referring to below link and trying to automate source changes refresh. https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources But when I run below statement i am getting b...

Answers: 0

The following fields are obligatory: table_name SOURCE_CHANGES()

derived view
asked 15-02-2019 13:05:09 -0500

Hi , Why i want use interface view why can't top-down implementation done on the derived it self.

Answers: 0

Join view OR Operator
answered 15-02-2019 10:08:42 -0500

Hi How to use OR operator in join condition my query looks like this bv_1.id = bv_order.id AND (UPPER(bv_code.CODETYPE) = 'ADMINISTRATIVEGENDER' **OR** bv_ce.C_CODE IN('4','5')) ERROR what i am getting currently The join condition is not vali...

Answers: 2

Denodo Monitor: way to log the trace for an incoming query
asked 15-02-2019 09:21:10 -0500

Hello, is there a way to configure denodo monitor to log the execution trace or the queryies going to underlying datasources for incoming Denodo Queries? Even when the incoming query does not specify it needs to be traced? Lets say I get incoming que...

Answers: 0

Are newer versions of subversion supported on Denodo 7
answered 15-02-2019 07:28:14 -0500

I noticed that the documentation refers to supporting Subversion 1.7. Our version of the CVS repository is slightly newer than that. Will it work correctly.

Answers: 1

VCS SVN

Create Base view from SQL query
answered 15-02-2019 07:24:08 -0500

Hello there! I'm tottaly new on Data Virtualization and Denodo I'm trying to create my first view from SQL query (PostgresSQL) Would you guys could help me o that? <image src="https://drive.google.com/open?id=0B5D_BLEYhiEMU2lXNmZXY09CUHRpM3R0VVNx...

Answers: 1

Denodo Express PostgreSQL Select Query

Windows services dependencies
answered 15-02-2019 06:58:24 -0500

Hi, is there a specific order or sequence that has to be kept in mind when starting the Denodo services on a Windows environment? Thanks in advance!

Answers: 1

windows

Return code from Denodo Scheduler after job completion.
answered 15-02-2019 06:29:15 -0500

Team , I am calling a Denodo Job using Scheduler-API script and its running fine.However, I need to capture the return code based on the RESULT (Complete/Fail). Can you please let me know how can we add this in scheduler API script? Or do we already ...

Answers: 2

Scheduler

days function
asked 14-02-2019 15:58:59 -0500

Hi Team I am able to execute on DB2 but not on the Denodo , is am i missing something (days(current_date)-days(view_a.DATEOFBIRTH))/365

Answers: 0

VDB error on the combination of to_date and formatdate functions
asked 14-02-2019 15:36:27 -0500

Hi Team I am using following functions on a filed but i am getting the VDB error Statement to_date('YYYYMMDD',formatdate('YYYYMMDD',cust.dateofbirth)) Error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing cap...

Answers: 0