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 September 2019.

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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Denodo Scheduler - UTC Time
answered 20-11-2019 11:16:51 -0500

Hi, I have an issue where our scheduler jobs are associated with UTC as opposed to local time. Our server is set to local time. How can I change the scheduler to use local time?

Answers: 1

Python JDBC access to Denodo
answered 20-11-2019 06:50:00 -0500

Hi, I have been trying connect our Denodo Server via python, I have been trying from windows and now from MacOs Mojave. I have read other JAYDEBE API posts, which basically Denodo Support team didn't/couldn't help. My code is below user = #### pasw ...

Answers: 1

JDBC Python

Differentiated Stages in Denodo Query Execution_1
answered 19-11-2019 11:38:44 -0500

Hi Team, just want to understand, how denodo can plan the exquery excecution. which is the right process? 1.Query parsing, optiomization, integration and excuting the query or 2.Query parsing,static optimization, dynamic optiomization and excuting the ...

Answers: 1

Denodo Query Exceqution Plan

Differentiated Stages in Denodo Query Execution
answered 19-11-2019 11:35:47 -0500

Hi Team, just want to understand, how denodo can plan the exquery excecution. which is the right process? 1.Query parsing, optiomization, integration and excuting the query or 2.Query parsing,static optimization, dynamic optiomization and excuting the ...

Answers: 1

Denodo Query Exceqution Plan

How to integrate google sheet with denodo
answered 19-11-2019 10:21:27 -0500

Hello, I am quite new to denodo and have an urgent requirement, wherein I need to integrate google sheet with denodo virtual port. Can anyone please explain the process of the same to me in detail.

Answers: 1

strip XML tags from a column
answered 19-11-2019 04:23:06 -0500

Hello, I am getting the data to a column as <p><span style="color: black; font-family: arial,sans-serif; font-size: 10pt;">1: Communication with CNF GM Wallice</span></p><p>hdsfgkwlfewfw</p<ul><li>somethin...

Answers: 3

XML HTML Tags

How to write if/then statements in Denodo
answered 19-11-2019 01:10:17 -0500

I am trying to write an in-DB formula that works. Here is what I have tried: case when "AUSP Value From" is 0 then "AUSP Character Value" else "AUSP Value From" end However, this formula has been unsuccessful. How can I write this formula in a way tha...

Answers: 2

DB2 on AS400
answered 18-11-2019 18:02:44 -0500

Connection established to DB2 on AS400 with jt400.jar. Query execution is failing with below error [JDBC ROUTE][ERROR] Received exception with message '(PWS9801) function rejected by user exit rpogram PUSEXTPGM in DPSMLIB The class name to register u...

Answers: 1

DB2

Disabling all jobs in scheduler
answered 18-11-2019 13:54:19 -0500

is there any way to disable all the jobs in Denodo 7 scheduler?

Answers: 1

Materialized Tables
answered 18-11-2019 13:51:57 -0500

Hi Team, Please provide differences between Materialized vs Temporary tables Their use cases Documentation links Thanks.

Answers: 1

materialized table