Q&A BY TAG 'VQL'

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

How to do the cache load for a view
answered 18-08-2020 08:50:38 -0400

How to load cache load for a view, we have kinds of cacje mode, full, partial, waht is the exact command? do we have artical to introduce it? Thank you.

Answers: 1

vql cache data preload

Dynamic JDBC source query parameter
answered 01-07-2020 06:38:37 -0400

How can I force dynamic filter on query to be executed against datasource? Example: SELECT name, surname FROM table WHERE id = GETSESSION('user') this does,not work. SELECT name, surname FROM table WHERE id = 'john' works but I would like to use sessio...

Answers: 5

VQL

import.sh run vql, which vql contained parameter, how to make it?
answered 26-05-2020 17:41:43 -0400

We have linux machine with denodo client installed, we use import.sh to run some vql file, I have a question, if my vql file wants to have a parameter such as where filters contain some parameter, can import.sh run that vql with parameter contained in ...

Answers: 3

vql vql parameter import.sh

vql for Import roles from LDAP data source
answered 21-04-2020 17:50:35 -0400

Hi all, I understand in VDP we can use “Import Roles from LDAP” wizard to import roles from LDAP data scouce, and I can see ldap data source defined in VDP database, if that do we have vql to import roles, which can does the same thing as the Import Ro...

Answers: 1

vql import ldap roles

VQL Required to add a data movement plan using Alter?
answered 01-04-2020 15:37:11 -0400

What is the VQL required to Alter a data movement plan? Here is the context from the CREATE statement: CREATE OR REPLACE VIEW sv_basespace_rundata as field1 field2 field3 CONTEXT (DATAMOVEMENTPLAN = iv_getsession_roles : JDBC datasources."ds_BaseSpace...

Answers: 1

VQL 7.0

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)
answered 30-03-2020 11:50:34 -0400

Hello Denodo Support Team, I understand that Denodo VQL supports TVFs (Table Value Functions) regarding the unpivoting of multiple columns in a view and joining to other sources. However, the most recent proposed solution for addressing the powerful UN...

Answers: 1

VQL unpivot cross apply

[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