Q&A BY TAG 'View'

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

Error: Invalid identifier (too long)
answered 04-06-2019 11:53:41 -0400

Hi team, I was trying to rename a view to a name with more than 100 characters and I got this error: Syntax error: invalid identifier: 'xxxxxxxxxxx' (too long) Is there any character restriction for object name in Denodo? Can I change something, i.e. i...

Answers: 2

Error View Server Configuration Changes

View Parameters disable
answered 05-04-2018 08:21:54 -0400

Hi! Im trying to do the DEN60EDU118 LAB01. In some point it ask us to use view parametes botton. When im trying to do it, the botton is disable it says: "This feature is not allloed by the licence"! I use de lincense provide by the express instalatio...

Answers: 3

Parameter View

Pivoting Denodo View Results
answered 12-03-2018 09:12:32 -0400

I have a SQL server procedure that pivots a table with unknown number of rows and these number of rows can be dynamic and change throughout the day; I have created a view to replace the sql server table but now I need to replicate or replace the stored...

Answers: 1

Denodo 6.0 Pivot custom wrapper View

Accessing Open Data API
answered 23-08-2017 07:32:08 -0400

Hello there, I was just curious, how can you access an Open Data API with Denodo to retrieve Data in real time to be provided as a web service, self-service, or views that can be combined with other disparate data sources? Thanks in advance.

Answers: 3

API users View Web Service

How to use "WITH" clause query using temporary tables to create a view in DENODO
answered 23-02-2017 11:58:26 -0500

I am trying to create a view using the query which is having WITH clause for temporary table but getting syntax error.. please help me asap. ex: WITH dept_count AS ( SELECT deptno, COUNT(*) AS dept_count,ROW_NUMBER() OVER(PARTITION BYdeptno ORDER BY...

Answers: 3

view WITH

Unable to rename a derived view
answered 20-12-2016 08:05:23 -0500

Hi, I am trying to rename a derived view "06_derived" to "05_derived" but im unable to do so howeveve im able to rename it with other name like "07_derived" etc.... Please let me know what can be the issue not much info on logs

Answers: 2

view derived view

Do we need to generate the statistics for Interface views
answered 07-12-2016 05:41:51 -0500

Generating statistics for base view is enough or generating statistic for interface views will also improve performance

Answers: 1

view VDP query optimisation interface Generate stats

How to add new columns to existing base view?
answered 22-08-2016 11:31:32 -0400

Hi Denodo team, I have created a view couple of days ago. Now, I want to add new fields to that existing base view. Can i do this? If any solution to this please let me know

Answers: 2

view v

Input parameter for view
answered 08-07-2016 09:10:53 -0400

Is it possible to set a input parameter in a selection view? We know that it is posible for a derived and base view. But we want to set a input parameter in our selection view. tnx in advanced

Answers: 1

view parameter

How to connect data source by using ODBC and how to create views on VDP adminstration tool.
answered 08-07-2016 08:07:58 -0400

Hi Denodo team, I have installed denodo vdp client 6.0 . i have one goal that to create view from database. I done the all pre requests for ODBC. 1. i installed ODBC drivers. 2. I configured server and database in ODBC data source in A...

Answers: 5

view VDP