Latest Activity

code

Refresh the views using vql.

I used GET_SOURCE_CHANGES() for getting the changes. But is there a way i can make that changes automatically either using vql or any other way. Right now i got the list of changes and i have to go and manually refresh the views. i have to just auto...

VQL Source refresh

code

get_view_columns

We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. ...

Microstrategy VQL get_view_columns

code

In view row_number() is not working expected.

In view row_number() is not working expected. but same query from VQL Shell giving me expected results. What is the issue ? I pass same where clause. From VQL shell which is need row_number 1 1 2 3 4 From View row_number 49 50 51 52 115 What caus...

VQL Vql shell row number

code

Not able to import a view and execute VQL's in VQL shell in Denodo 7.0 express edition

Hi Team, Good Day! I was trying to export and import the entire database that I have created within my local to another local machine and it works. I could move my entire DB to another system. But after sometime, I thought of moving some edited view to...

VQL Import Export

code

vql

Hi Team, Denodo 5.5 I have a requirement to find all the views which uses 'In' or 'Between'. How can this be know. Thanks.

VQL Denodo 5.5

code

Make Server Configuration Changes VIA VQL

Is it possible to make to server configuration changes using VQL? For example, is it possible to alter kerberos settings, like adding User Base values?

VQL Server Configuration Changes

code

Example Denodo Stored Procedure to interact with SQL Server Stored Procedure

Hi, Denodo Where can I find some example denodo stored procedures to takes some input parameters to feed into an MS SQL server stored procedure(not regular SQL scripts) that does some analysis and returns a table, for joining with other denodo base vi...

VQL Denodo stored procedure

code

Strange syntax error when attempting to add a column to a derived view

I have an existing derived view that I"d like to add a column to but I'm getting an unexpected error. The sourve view has 3 columns: source_id (int datatype) timestamp (int datatype) value (int datatype) The timestamp field is an Epoch timestamp that...

VQL addsecond

code

Create a Comma Seperated List (CSV) as part of query resultsL

Is it possible to convert a list of values into a csv string as part of query result? Ex: Customer | Item John | Glove John | Bat Desired output: Customer | Items John | Glove, Bat In SQL Server, i would use syntax like shown in this article. https:...

VQL CSV

code

cache refresh info

Hi Guys, is it possible to get a list of views having caching enabled, to check their latest cache refresh using VQL? If not using VQL, does Denodo have other ways to check for caching info about views?

VQL VDP Cache