Latest Activity

code

PK and FK during meta data creation

Hi Team, When we create base views from source RDBMS - does Denodo also picks up all the constraints from base source tables ? Like PK and FK ? I see details about primary key in community but what about other constraints ! Regards, Sandeep

code

denodo express usage policy

Hi, I want to use the denodo express. However, I need to check if I can install it on my company's computer. I think it doesn't matter because it's a free version, but is there any documentation that can confirm that there are no problems with the in...

code

Create Base View from query

Hello, When creating a base view from query, I am always successful when creating a base view from query when I do a straight select with condititions. However I noticed when I try to put in a query where I create temp tables it does not work. Is there...

code

Got ORA-12705: Cannot access NLS data files or invalid environment specified when testing connection to Oracle 11g data source

I installed Denodo Training QuickStart Virtual Machine (DQVM) and Denodo Express 8.0 for Windows. And when I try to test connection to data source (jdbc:oracle:thin:@data-server:1521:xe) the "ORA-12705: Cannot access NLS data files or invalid environme...

code

how to rename a derived view column name

ALTER VIEW xyz( ALTER COLUMN abc RENAME column mnn); how can we rename a derived view column name

code

Store procedure does not execute connect statement

I am getting error message while executing connect statement in Store procedure. Is there other syntax or way to connect database within store procedure? Error message: 'Finished with error: Could not execute a connect during a transaction.' I have use...

code

Debug vql stored procedures

Hi, How to debug vql stored procedures with print statements? I need understand what my vql stored procedure execute in same steps. I try some commands (print, display) but it isn't work. Any ideias? Thanks.

code

Time-out issues when joining multiple tables

Hi i have this timeout issue each time i tried to run a query where joining multiple tables required. I only join between 2-3 tables and it already gave me a timeout issue. How do I fix this errror? The entire message is as follows: Finished with err...

code

ALTER statement not working on Store proc

I am trying to execute alter statement to update table description. There are multiple databases so I am getting table not found error while executing below statement. EXECUTE 'ALTER TABLE :param2 DESCRIPTION = '':param3''' PARAMETERS(param2, param3 ) ...

code

Dynamic Parameter in CONTEXT is not actually passing through Denodo

Hi , I am in the use case where VQL shell applies fectch limit(Delegation to source is set YES in Datasource config) and gets result in 10-20 secs for any base view, while the same connection I am using in DBeaver(has its own limit of 200 records)--&...