Latest Activity

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

code

How can get all database URL in denodo

Hi Denodo Community , Please , I need your help , How can get database URL in denodo , using VQL or any other solution Thank you a lot .

VQL GET_VIEWS VQL Base view database URI GET_SOURCE_TABLE URL GET_ELEMENTS

code

Query a field in a register in denodo

Hi, Can we query a subfield from a register in vql shell without knowing the exact path of the subfield. is there a query like : select [subfield name] from xxview. So if the subfield is under register1.register2..registerN, we dont have to specify th...

vql register

code

Transform text to data

HI everyone, I have a task to transform a text field to a timestamp field. The content of the initial field looks like this: "2017007", so it's like "YYYY0MM". I was trying aroudn with totimestamptz, but I don't know how to deal with this 0 in the ...

VQL

code

VQL to identify obligatory parameters/search methods via VQL

How do you determine the mandatory parameters/search methods given a view using VQL?

VQL Parameter

code

VQL - Identifying non fully-delegated queries

Is there a way to determine which queries Denodo will not delegate in full to source via VQL or otherwise ?

VQL