Q&A BY TAG 'Vql shell'

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

creating a base view off of a working script in VQL Shell
answered 10-03-2021 10:04:35 -0500

I have the following code that is working to produce a result but I am not 100% sure how to turn it into a baseview that I can join against another existing view. select * from (select * from hcc_dv_dev.bv_ctigeneral_s3_ldap_matrix_regionsector)a RIGH...

Answers: 1

select query Vql shell Create Base View

Setting CONTEXT ('formatted' = 'yes') as default?
answered 24-02-2021 07:44:43 -0500

Is there a way I can have the system, by defult, add "CONTEXT ('formatted' = 'yes')" to the end of a derived view when I use the VQL Shell to create views, instead of having to write it out at the end of every script?

Answers: 1

VQL vql shell context formatting

Workaround for double quotes around database name in queries
answered 16-02-2021 11:48:05 -0500

I'm trying to see how I can configure my database to not need the double quotes around the database name when using queries in the VQL Shell. I realize there is a Restricted vs Unicode configuration that I think I've turned on, but I'm still having to ...

Answers: 1

Denodo 8.0 double quote Vql shell Database unicode

VQL statement and visual query formatting
answered 27-01-2021 06:27:35 -0500

Hi, I am wondering if there is a tool or add-on similar to that of RedGate SQL formatting capability to facilitate vql code debugging. The vql formatting appears to be lost when exporting vql code from the VDP admin tool.

Answers: 1

Vql shell format vql

vql shell command to VCS commit and VCS push?
answered 08-09-2020 04:42:42 -0400

Hi team, I understand we have VCS vql shell command for pull (DVCSPULL DBELEMENTS database_name), do we have the same for VCS commit and VCS push operation?

Answers: 1

vql shell VCS push VCS commit

python to run vql shell (select , create view, desc view)
answered 31-08-2020 07:20:47 -0400

Hi Team, I am using python to connect Denodo ad want to run some vql, I am using JDBC connection to connect denodo with python library "jaydebeapi", when I ran some select vql query, it works. But I encounter below two problems, can you help check: ...

Answers: 1

vql shell python create view desc view

Does Denodo has the command to change the view's cache mode ? eg, from cache "Off" to "Partial", or cache "Off" to "Full"
answered 17-08-2020 01:04:21 -0400

Does Denodo has the command to change the view's cache mode ? eg, from cache "Off" to "Partial", or cache "Off" to "Full" . Thanks, we need this kind of command for some aotumation tasks. Not want to do it from VDP client.

Answers: 1

vql shell cache mode store procedure

vql shell command or existing store procedure to gathering statistics
answered 14-08-2020 17:54:08 -0400

Do we have some exsiting vql shell command or store procedure which is for stastics gathering, we want to use some command to do the statistics gathering. Thanks.

Answers: 1

vql shell Gather Statistics

vql shell to return all the views under some folder
answered 10-08-2020 05:09:32 -0400

Do we have vql shell that can return all the object name under one folder, including view, associations or folder? The purpose is to get all the object under one folder by script, such as python script. Thanks.

Answers: 1

vql shell view name

In view row_number() is not working expected.
answered 01-10-2019 06:13:59 -0400

In view row_number() is not working expected. but same query from VQL Shell giving me expected results. What is the issue ? I pass same where clause. From VQL shell which is need row_number 1 1 2 3 4 From View row_number 49 50 51 52 115 What caus...

Answers: 3

VQL Vql shell row number