Q&A BY TAG 'vql'

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

dynamically create derived views based on list of multiple base views
answered 15-11-2021 16:50:51 -0500

Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...

Answers: 1

VQL Dynamic Loops Derived views

INSERT INTO with SELECT
answered 18-10-2021 04:32:01 -0400

Hi Team, Could you please confirm the below limitation of VQL syntax. Working - INSERT INTO view2 SELECT col1 FROM view1; Working - INSERT INTO view2 (col1) VALUES ("abc"); Not working - INSERT INTO view2 (col1) SELECT col1 FROM view1; Not working - ...

Answers: 3

VQL syntax insert

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