Latest Activity

code

Fetching Column issue in VQL

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select <Column_name> from <data_base>.<Base_view_name> throwin...

VQL SAP DENODO SAP BW/4HANA

code

vql to invalidate cache (base views, derived views)

Hi team, I want to find out vql to invalidate cache, I run below for a base views, but it has error "selected view: 'base_view_name' is a base view": ALTER VIEW base_view_name CACHE INVALIDATE it cna only run for derived view: ALTER VIEW derived_view_...

base view vql invalidate cache

code

For base view vql, what does "ESCAPE" mean?

I just observer the vql of the base view (data source is Hadoop Dremio), for the columns whose sourcetypename='CHARACTER VARYING', some has the attribute "ESCAPE NOT SORTABLE" , some has the attribute "NOT SORTABLE", why for the same data type, they ha...

base view vql ESCAPE

code

How to do the cache load for a view

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.

vql cache data preload

code

Dynamic JDBC source query parameter

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

VQL

code

import.sh run vql, which vql contained parameter, how to make it?

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

vql vql parameter import.sh

code

vql for Import roles from LDAP data source

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

vql import ldap roles

code

VQL Required to add a data movement plan using Alter?

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

VQL 7.0

code

[SQL0401] Comparison operator = operands not compatible.

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

VQL

code

How to get VQL command metadata response message using JDBC connection.

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

VQL VQL Role