Q&A BY TAG 'VQL'

You must sign in to ask a question. If you do not have an account, you can register here

[SQL0401] Comparison operator = operands not compatible.
answered 24-02-2020 07:58:57 -0500

Error : [SQL0401] Comparison operator = operands not compatible. DataSource is DB2. and data type of DATE_TRANSACTION IS date(deprecated) None of the below query works. Queries: SELECT FROM "Discovery_FiservODS"."EFT_TRANS_HISTORY" WHERE "DATE_TRAN...

Answers: 1

VQL

How to get VQL command metadata response message using JDBC connection.
answered 14-02-2020 07:18:59 -0500

Hi Team, I am using JDBC connection to execute the VQL commands from my application. Let's say I want to create a role or modify the description of the role using 'Create /Alter command query' as shown in example below For example: Create role testro...

Answers: 3

VQL VQL Role

Refresh the views using vql.
answered 31-01-2020 02:26:07 -0500

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

Answers: 1

VQL Source refresh

get_view_columns
answered 01-10-2019 06:44:41 -0400

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

Answers: 1

Microstrategy VQL get_view_columns

In view row_number() is not working expected.
answered 01-10-2019 06:13:59 -0400

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

Answers: 3

VQL Vql shell row number

Not able to import a view and execute VQL's in VQL shell in Denodo 7.0 express edition
answered 03-06-2019 12:08:23 -0400

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

Answers: 1

VQL Import Export

vql
answered 29-05-2019 06:15:41 -0400

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.

Answers: 3

VQL Denodo 5.5

Make Server Configuration Changes VIA VQL
answered 23-04-2019 18:17:48 -0400

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?

Answers: 1

VQL Server Configuration Changes

Example Denodo Stored Procedure to interact with SQL Server Stored Procedure
answered 27-12-2018 16:37:43 -0500

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

Answers: 3

VQL Denodo stored procedure

Strange syntax error when attempting to add a column to a derived view
answered 27-11-2018 15:14:03 -0500

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

Answers: 1

VQL addsecond