Latest Activity


Create LDAP User using VQL

All, I searched the forums, but all i could find are references to the VQL docs and another stating we shouldn't create ldap users using VQL. I'm trying to follow the syntax in the VQL guide but am not having any luck creating an LDAP user via VQL. H...

VQL LDAP Create User


Need to find Pipe character in a column value

I need to find the Pipe character ( | ) in the column value of a field in a view.This is the SQL I am using for my query, however I am not having luck in the reults: SELECT * FROM "My_View" where instr(my_column,'|') <> 0 Please let me know the ...

VQL instr function


Adding Logic to Join View

Hello, I am having some issues designing a solution to a feature that I need to create. Scenario: I have a data set with a specific field that needs to be modified when a condition true is passed in from the web service and not modified when a condi...

VQL REST join Logic Web Service


Common Table Expression (CTE) getting an error

Hi, i'm converting my CTE codes from SQL server to Denodo/VQL but i'm getting an error it say "QUERY VIRTUAL ERROR". I have a multiple CTE's in my script but when i use a left join in my final query using the result of CTE i'm getting an error and some...

VQL VQL simple condition DENODO


Error obtaining VQL in base views. Missing read privilege on the wrapper

Hi, I have read and write privilege on a virtual database. For the base views when I click the VQL tab to see the VQL associated with the view I am getting an error as below: Error obtaining vql: The user does not have READ privileges on the wrappe...

VQL base view Wrapper


Retry unless Date_Column date matches with CURRENT_DATE()

I want to create a VDP job in scheduler which must keep retrying unless the column returns a row which is equal to CURRENT_DATE() select count(*) from Table where Date_Column = CURRENT_DATE() This query must get completed in scheduler only if the cou...

VQL Scheduler DENODO SQL Server


Calling a Stored Procedure within another Stored Procedure

I want to know if I can call a Stored Procedure from another Stored Procedure. For example I want to Generate the Statistics for all Derived Views in a particular VDP database. The "GENERATE_STATS" stored procedure uses the View name as a parameter The...

VQL Stored Procedures


How to provide default value for parameter if user don't provide any value

In our example we have two parameters which are optional. We want in such a way that if parameters are not provided we provide some default values. How to provide default value for parameter if user don't provide any values while executing VQL?



Find position of a certain character via VQL sql

I have a field with the following value (the file path and the file name): \N9000SF2\Investments\home_old\inv\HOME\HISIRXW\INVDB\INVDB FINAL 01 25 2008\Data Definition Reports\Rei Model Definitions.xls I want the result to be everything except the fil...



Vql to get Dendodo Server name

Hi Denodo, Is there anywat that i can get Denodo Server name using VQL,I am asking similar function like @@servername in Sql Server.