Q&A BY TAG 'VQL'
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
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 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 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 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
[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
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
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
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
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