Q&A

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

Denodo virtual machine
answered 18-11-2019 06:36:00 -0500

Hello, I tried downloading Download Denodo Training 7.0 QuickStart Virtual Machine several times but without success. The zip file is 1.5 GB in size but can not completely finish the download of Denodo Training 7.0 QuickStart Virtual Machine.zip file. ...

Answers: 1

Denodo Training 7.0 QuickStart Virtual Machine

Connect to Denodo from Azure Data Studio?
answered 15-11-2019 17:23:16 -0500

Hello I tried connecting to Denodo 7 from Azure Data Studio using the PostgreSQL plugin and following these instruction: https://community.denodo.com/kb/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP?category=Northbound+Connect...

Answers: 1

Add a timezone to a timestamp in JSON data source
answered 15-11-2019 12:48:06 -0500

Hi, I am retrieving web based data which has fields formatted as a timestamp with no timezone (eg. <opened>2019-11-14 17:00:00</opened> ). The data source is in GMT. My timezone is us_mst_mdt. I would like to get the wrapper and base view...

Answers: 1

Technical Analyst
answered 15-11-2019 12:39:00 -0500

Hi Team, I am trying to connect the Denodo Virtual Data Port administrator tool (installed on my local machine in windows) to the Denodo Virtual Dataport server server installed on a AWS EC2 Linux machine. Can you please suggest the steps that I need t...

Answers: 1

Installation Connection

Find the column name group by
answered 15-11-2019 10:10:53 -0500

Hi Team, I like to list all the group by columns which we are using in view through the pre defined stored procedures like GET_VIEW_COLUMNS Thanks Balu S

Answers: 1

pre defined procedures