Q&A BY TAG 'vql'

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

Create LDAP User using VQL
answered 17-10-2017 01:06:00 -0400

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

Answers: 3

VQL LDAP Create User

Need to find Pipe character in a column value
answered 26-09-2017 01:11:55 -0400

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

Answers: 1

VQL instr function

Adding Logic to Join View
answered 18-09-2017 08:47:01 -0400

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

Answers: 1

VQL REST join Logic Web Service

Common Table Expression (CTE) getting an error
answered 05-09-2017 09:01:20 -0400

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

Answers: 1

VQL VQL simple condition DENODO

Error obtaining VQL in base views. Missing read privilege on the wrapper
answered 23-08-2017 08:37:10 -0400

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

Answers: 1

VQL base view Wrapper

Retry unless Date_Column date matches with CURRENT_DATE()
answered 04-07-2017 09:35:32 -0400

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

Answers: 1

VQL Scheduler DENODO SQL Server

Calling a Stored Procedure within another Stored Procedure
answered 25-05-2017 04:43:19 -0400

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

Answers: 1

VQL Stored Procedures

How to provide default value for parameter if user don't provide any value
answered 18-04-2017 09:12:12 -0400

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?

Answers: 1

VQL

Find position of a certain character via VQL sql
answered 17-04-2017 08:16:32 -0400

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

Answers: 1

VQL Vql

Vql to get Dendodo Server name
answered 12-04-2017 09:00:48 -0400

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

Answers: 1

VQL