Latest Activity

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)--&...

code

Connect to Alteryx from Denodo

Hi, Has anyone explored connecting to an Alteryx datasource from Denodo? If yes, could you please share the details on how to? Many thanks.

code

Denodo addmonth equivalent

Hi I have a teradata condition as: select (EXTRACT(MONTH FROM ADD_MONTH(DATE , 0) -6) FROM TABLE_NAME. what will be the equivalent of this query in denodo, as denodo is throwing error Thanks

code

Issue while connecting to Denodo database through ODBC from ASP.NET CORE 3.1

I am trying to connect to Denodo database using ODBC connection from ASP.NET CORE 3.1 I am facing the following issue:- System.Data.Odbc.OdbcException: 'ERROR [08001] connction string lacks some options' Below is my code snippet:- "string connections...