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.

How to concatenate column values in VQL?
answered 28-09-2018 02:25:51 -0400

Hi, I have this in Oracle. select 'A' || ', ' || 'B' || ', ' || 'C' from dual How do you do this in VQL? Thanks.

Answers: 3

Connect to a Siebel Offline database?
answered 28-09-2018 02:24:49 -0400

Hello, I would like to how if anyone has been able to connect to an offline siebel database

Answers: 1

Connecting R to Denodo
answered 27-09-2018 23:23:43 -0400

Has anyone successfully connected to Denodo using Rstudio or any of the R tools using JDBC?

Answers: 1

Denodo 7 R JDBC

Using Regexp_like in Case in Select
answered 27-09-2018 11:26:31 -0400

Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...

Answers: 2

REGEXP_LIKE Select Query CASE

xpath function is not working as expected in Denodo
answered 26-09-2018 19:20:25 -0400

SELECT xpath ( cast ('xml' , '<Entries> <ChargebackClaim DebitMemoRefNum="61186134101">123 </ChargebackClaim> </Entries>' ) , '/Entries/ChargebackClaim/@DebitMemoRefNum/text()', true) as xpath_results FROM Dual(); I am getting...

Answers: 2

XML

update values in log4j2.xml using virtual dataport VQL
answered 26-09-2018 10:47:00 -0400

I've seen commands to update configuration parameters. Is it possible to change the "filename" and "filePattern" parameter within "RollingFile" for QUERIESOUT using VQL ? Or has this to be done by editing log4j2.xml directly?

Answers: 1

Virtual DataPort v6.0 log4j2.xml

Interpolation of function and variable.
answered 26-09-2018 08:27:23 -0400

I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...

Answers: 1

Function Interpolation Variables oracle

Denodo Cache issue in Denodo 5.0 vs 6.0
answered 26-09-2018 05:07:42 -0400

Hi Team, We need your clarification here, how Denodo create Cache Table in Cache DB, below is the my question: we are using Denodo 5.0 now and migrating code into 6.0. here, we have a view in Denodo 5.0 it is full cached (oracle is Cache DB). just exam...

Answers: 1

When trying to use the concat function, I get an error saying that it is not a recognized built-in function name.
answered 26-09-2018 00:16:31 -0400

When trying to use the concat function, I get an error saying that it is not a recognized built-in function name. Below is a sample script that gives the same error. SELECT t1.api_no14 PID, t1.automation_name WELL_NAME, t2.CREATE_DATE COMMENT_DATE, t2...

Answers: 1

Hive connection issue with Denodo VDP
answered 25-09-2018 23:15:12 -0400

Hi Team, Product Name: Virtual DataPort 7.0 (Express) Hive Version: Hive v1.1.0 CDH (Cloudera Distribution Hadoop): v 5.13.0 Database Adapter : Hive 2.0.0 (HiveServer2) Driver Class path : 'hive-2.0.0' Driver Class : org.apache.hive.jdbc.HiveDriver D...

Answers: 1

Denodo and Hive