Home / Q&A / All Questions

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.

Stored procedure returning data only with "call" statement and not with "select"
answered 26-12-2017 07:24:00 -0500

I have created a stored procedure which returns an Array. It is not performing any DML operations and is only retrieving data, parsing it and giving back an array. However, I can only view the data using "call" statement. The "select" statement is retu...

Answers: 5

Stored Procedures

Denodo platform for other service
answered 26-12-2017 07:16:14 -0500

I was reading through denodo platform for various services like AWS and Azure . Are there any other services or ways to implement Denodo platform ??

Answers: 1

STORED PROCEDURES NOT DISPLAYED IN TREE DATA SOURCE
answered 26-12-2017 07:03:05 -0500

Hi: I'm attempting to execute the LAB03 however stored Procedures are not displayed in the data tree source. Can you please let me know why are not displayed? If something is missing? I attach the image where procedures are correctly created in MYSQL b...

Answers: 1

Stored Procedures

Unable to read Unicode character columns in views
answered 22-12-2017 07:21:58 -0500

we built some base views off RMS sql files. three columns have elements that are formatted “ObjectValueTypUnicode” datatype. the columns do not appear in the output on a SELECT * base view build. Just not there while every other field is populated and ...

Answers: 1

unicode

Is there new installation/hardware guidelines for Denodo 7.0 Beta version?
answered 22-12-2017 06:27:55 -0500

Is there new installation/hardware guidelines for Denodo 7.0 Beta version? I know solultion manager is a new tool is there new documentation for that piece?

Answers: 1

Edit query when creating a BASE VIEW
answered 22-12-2017 04:52:40 -0500

Hi Community: I'm new using the tool and when creating a base view I used he option create from query. I'm trying to edit the query used for a base view created is this possible? If yes please let me know which are the steps Thanks for your help

Answers: 2

Base view

DESC VQL
answered 21-12-2017 19:42:03 -0500

Is there way can we export DESC VQL FOLDER '/02_base_views' ('includecontents'='yes') to csv file or expose as any other table ? Bascially we need to apply some filter after the export Thanks in Advance

Answers: 1

VQL

Association without push down over BAPI
answered 21-12-2017 07:54:02 -0500

Hello Community, while working with Denodo I got a Problem, that I can´t deal with. I have a Database with about 150 Mio lines which I want to filter for more than one criteria. This needs very much time by doing all with the help of the SAP-Server. Wh...

Answers: 2

BAP Connector SAP Association

Denodo TDE memory map extracts
answered 21-12-2017 06:57:47 -0500

Hi, We are currently using a java code that's using Tableau SDE to create .TDE files from VDP(using JDBC driver). Is there a way to not extract VDP restfull web service to .TDE just like JSON or XML file. Also what possible way we can generate TDE ext...

Answers: 1

Web services TDE

Rounding 2 decimals not working as expected
answered 21-12-2017 04:51:16 -0500

Hi team! I'm looking for a way to ensure we are forcing the decimal number to have 2 decimals, now I'm having problems with those decimals that have only 1 digit. Please, see image in the below link. I'm using the Round function in this way: Round(&l...

Answers: 3

round decimal