Latest Activity

code

REPLACEMAP and CR/LF char(10)....

Hi Denodo Team, i want to Replace CR and LF in some columns. With Replace this is no Problem and working fine. REPLACE(REPLACE(column1, char(10), ''), char(13),'') But for future use i want a MAP for this. CREATE MAP simple forbidden_chars ( ...

VQL

code

VQL Query to Cache view - is there an include all rows command

For the VQL statement to cache view1 below, if this query is executed in a query window and the checkbox to "Retrieve all rows" is not selected, the query will cache only the number of records listed in "Limit displayed rows:" SELECT * FROM view1 CONT...

VQL CACHE

code

Select and Update Logical Field Name using VQL

We have activated the logical field name in Denodo Catalog by using thge Allow logical names for view fields in the administration/personalization section. We would like to know how we can retrieve and update the logical name values in a batch such as...

VQL ALTER Logical Field Name

code

Using a select statment when implementing a interface

Hi everyone. I need to create an interface with dynamic values on the interface definition. I will give an example to show what I mean: Normally an interface is created this way: CREATE OR REPLACE INTERFACE VIEW i_inventory_50 ( productpartnumber_0:...

VQL Denodo 8.0 select Interface

code

VQL stored procedure-error cursor

Hi, I am trying to create this stored procedure: ( nomeview IN VARCHAR) AS ( // Procedure variables v_name VARCHAR; database_name VARCHAR; Interface_name VARCHAR; CURSOR interfaces IS 'SELECT view_name FROM VIEW_DEPENDENCIES() WHERE view_database_name...

VQL Denodo 8.0 VQL Stored Procedure Error

code

how to prevent changed column names in baseViews from adding "_0"

I have several SQL Server tables where there are column names with spaces. The datasource shows the spaces, but the baseViews column names are created with no spaces and append '_0' to the column names. What configuration or setting can prevent the...

VQL

code

Automate Delimited file Base View creation

Hello, We are looking to automate view creation using VQL from a delimited file data source. We are currently able to create a delimited data source and create the views themselves, however it requires the attributes to be provided while creating the ...

vql metadata file delimited

code

vql to re-order the denodo rules setting

Hi team, we have new rules setting, and it has some conflicts of existing rules, but new rules should be the 1st priority, do you know after create new rules, how to use vql to make the new rules is before the existing old rules. It will be helpful for...

vql order change rules

code

Can Denodo VQL send emails?

I created a view that tists the metagroups (roles) that have been imported into Denodo. I'd like to send an email to these metagroups whenever there is an expected outage (when upgrading), or when a Denodo restored to service when it unexpectedly goes ...

VQL Custom stored procedure email

code

Extracting text from a field using delimiter

Hi I have a field which contains text. Id like to extract a certain part of that text field which being "Model: 123 Customer ABC" I would like to extract only the "123" part of this field Any help would appreciated Thanks D

VQL string conversion