Q&A

The incoming request has too many parameters
answered 31-12-2018 05:43:08 -0500

Hello, I am trying to create a union view. I am getting this error while executing the query: Finished with error: Error executing query. Total time 2.36 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Receiv...

Answers: 1

Denodo Abbrivation Function
answered 28-12-2018 08:13:03 -0500

Hi I am getting column from my DB with TimeZone : Eastern Time Zone i want to make this as EST like i have 24 Different timezones on my table . if my time zone changes EST to EDT i want to atomatically populate EDT on my column. how i am suppose to a...

Answers: 1

Fetching VQL
answered 28-12-2018 07:26:34 -0500

Hi Team , I am trying to create a store procedure to fetch VQL of views. Below is query to get VQL. "DESC VQL VIEW <name> ('dropElements' = 'no', 'replaceExistingElements' = 'yes', 'includeDependencies' = 'no') " Is there any other way to get ...

Answers: 1

Custom messages or exceptions for Rest API
answered 28-12-2018 07:05:17 -0500

Hi Team, When I publish a View via REST API when we don't have data for respective input parameter given denodo throws for example 200 or 400 error codes so instead of it can I throw error as No Data for 200 and 500 as Server down etc.. Kindly suggest...

Answers: 1

Sharing The Data sources
answered 28-12-2018 04:19:43 -0500

Could you please explaing the Second approach in details with valid example,i would like to implement the same.

Answers: 1
Related to: Sharing data sources

Example Denodo Stored Procedure to interact with SQL Server Stored Procedure
answered 27-12-2018 16:37:43 -0500

Hi, Denodo Where can I find some example denodo stored procedures to takes some input parameters to feed into an MS SQL server stored procedure(not regular SQL scripts) that does some analysis and returns a table, for joining with other denodo base vi...

Answers: 3

VQL Denodo stored procedure

Customized Store Proc
answered 27-12-2018 07:25:55 -0500

*Hi team, I am trying to execute below Store Proc query. but i am getting null value as output in denodo. could you please check and let me know where i am making mistakes.* package com.acme.extension; import java.io.Serializable; import java.sql.Re...

Answers: 1

CATALOG_PERMISSIONS in v7
answered 27-12-2018 07:10:08 -0500

What is the equivalent of a view/database read permission in version 6? if i want to give users read-only for all the views in a database, how do I do that? Do you have a document that explain what each attributes in catalogpermission mean? I assume th...

Answers: 1

VDP admin use remote powershell commands?
answered 26-12-2018 10:38:40 -0500

Hello does VDP admin or denodo scheduler or something else within Denodo make use of WinRM plugins or remote powershell commands? i.e. triggering the "wsmprovhost.exe" to consume quite a bit CPU. It uses a lot of CPU on our Denodo test machine and we...

Answers: 1

Associations not carrying over to derived view from base views?
answered 26-12-2018 10:33:53 -0500

When creating a derived view from base views that have associations, how come the new derived view does not have those associations? Have to recreate all of them.

Answers: 2

associations