Q&A BY TAG 'VQL'

Is it possible to add somehow another interpolation variable to interpolation function suffix. Following does not work. input2 does not get resolved to value ^ExecuteIfIsNotNull(" WHEN ",@input1," = 4 THEN @{input2}")

VQL

So, we have the following layers that we have built in Denodo: [[BOTTOM]] --Base views (tables from data source) --Derived views (again, the tables) --Combined views (formatted tables) --Service views (tables rearranged to data objects) --REST Web Ser...

VQL automate

Is it possible to derive container Folder of a data sources or a base views using catalog vqls?

VQL

is it possible that I VQL query from external application using JDBC to find Folder name which contains a given view/data source name? Also is it possible to VQL query from external application using JDBC to find the database name of a given data sour...

VQL JDBC

Is it possible to use NOLOCK hint in select statement on SQL Source

VQL Sql performance SQL Server

Hi, Is it possible for a custom Denodo Function to execute a vql statement? I am trying to insert something like this into my function: ResultSet resultSet = getEnvironment().executeQuery(query, params); Thanks!

VQL Custom Functions

I have exported VIEWS from my dev Denodo and tried to import that to my local. It got imported successfully. But when I am executing the VIEWs, it is throwing me below error: Finished with error: No search methods ready to be run. The following fields...

VQL import vql import export

Hello, We are trying to create a job that will run the VQL of "DESC VQL DATABASE" that we have stored in a CSV file. For our extration we just have the file parameter, the datasource of the file, and the parameter mappings of the file and source 0. ...

Vql Scheduler

Hi, I have connected to a hive datasource and imported a table using "Create selected base views". I can see the table on the left hand side panel. But when I execute the view, the following error pops up : TABLE [BASE] [ERROR] TABLE [JDBC WRAPPER] [...

VQL meta data view VDP query

I have to connect multiple database and create multi cluster environment, I want to know where to put VQL for multi cluster environment and which would be the best way to control configure VQL. Is it require multiple VQL or single VQL can control all?

VQL