Q&A BY TAG 'vql'

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

Changing JDBC Connection Password with VQL
answered 17-09-2021 01:49:43 -0400

Hi, I need help constructing the correct VQL to change the password for a JDBC connection within VDP? I believe it is something like: ALTER DATASOURCE JDBC connectionname ENCRYPT_PASSWORD 'thisisthenewpassword';

Answers: 1

vql JDBC Password

Compounding a derived view
answered 14-09-2021 12:48:18 -0400

Hello, I am working on duplicating the behavior of an API, it works pretty good, all the fields are mapped etc. However, the in-place API expose the data after structuring it : { "cat1": { "a":"toto", "b":"titi" }, "cat2" :{ "c":"tata" } } while the d...

Answers: 2

VQL REST Webservice Derived views

Preserving VQL formatting when using Edit Mode
answered 03-09-2021 19:53:00 -0400

I generally work in the VQL mode in the Virtual DataPort tool and wish to retain my formatting. I use the "CONTEXT('formatted' = 'yes')" clause regularly, but even with that, I've noticed the formatting gets reverted back to default (including view ali...

Answers: 1

VQL formatting

Create Base View for Oracle Function that returns Table Type
answered 25-08-2021 07:21:24 -0400

I am trying to create a base view on a Oracle function that returns data type - TABLE Trying this from the normal flow gives error : "Unsupported type TABLE for Database : Oracle Stored Procedure" How can i create this using a "Create Base View from VQ...

Answers: 1

VQL VQL Base view Custom Functions Stored Procedure Oracle

Is there a query to get a list of views with EXECUTE permission for current user?
answered 26-07-2021 17:08:48 -0400

I want to list views accessible by the current logged user. Seems I should use GET_VIEWS(), GET_PERMISSIONS() and GET_EFFECTIVE_PERMISSIONS(), but cannot realize how

Answers: 2

VQL predefined stored procs

VQL to show all cached sources and when it was last refreshed?
answered 01-06-2021 17:37:03 -0400

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...

Answers: 1

vql query LASTCACHEREFRESH Cache

Help rewriting REGEXP_LIKE Query to VQL
answered 16-04-2021 05:39:36 -0400

We are needing some assistance/suggestions in rewriting the following Oracle query. Query is basically creating a list(listagg) of a list of regions gathered from abc.table123 (security config table, each row is different region), and then needs to be ...

Answers: 1

VQL REGEXP_LIKE regexp_like Oracle SQL to VQL Converter SQL to VQL to_char

Aggregation of derived views delegating search methods to base view
answered 02-04-2021 07:46:17 -0400

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

Answers: 3

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)
answered 01-04-2021 08:46:28 -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: 3

VQL unpivot cross apply

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

VQL Denodo 7.0 search methods join Derived views