Latest Activity
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 ( ...
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...
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...
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:...
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...
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...
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 ...
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...
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 ...
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