Q&A BY TAG 'denodo'

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

Make input parameters optional when importing a SQL Stored Procedure
answered 08-11-2017 06:55:56 -0500

Hello, I have a Stored Procedure in SQL. I imported it into Denodo and made a RESTful service from it. Here I am seeing all the input fields as required in the service. I want to make all the input fields as optional and if I don't give any value to t...

Answers: 1

REST API Denodo Stored Procedure

Finished with error: No search methods ready to be run. The following fields are obligatory:
answered 23-10-2017 09:57:39 -0400

Hi, Created one customized Base view. On top of that created selection view with parameter (from view parameter option; Passed teh default value as well). In where condition pass this parameters like: "BV_fact_table"."TC_D_TXN_VALUE_AS_OF_DATE" >=...

Answers: 1


Need to delegate the date column's data into two different databases-Hadoop and Oracle, but facing issue.
answered 23-10-2017 09:56:53 -0400

Hi Team, Scenario is like that: I have a Union View which is based on Hadoop+Oracle. Now, when I am mentioning any date condition like 'dd-MON-yy' (while executing), I am getting the result from Oracle but from Hadoop( Impala) I am not getting any re...

Answers: 1


How to Delegate to_date function instead of to_timestamp into Oracle DB-at runtime
answered 23-10-2017 09:31:53 -0400

Hi, I created base view with interpolation variable (where expression) where I am passing “where” condition at runtime. But when I am passing the date value from denodo, from execution plan I do see the date value is converting to timestamp always and...

Answers: 3


No search methods ready to be run
answered 18-10-2017 07:46:54 -0400

Hi, I created base view. On top of that created selection/derive view and there I created parameter. That parameter I used in join codnition with respective field. But when I am running that selection view by passing parameter below error is coming; ...

Answers: 1


Is it possible to create volatile table(temp table) in teradata via Denodo?
answered 12-10-2017 02:59:25 -0400

I was trying to create a baseview in denodo by using the below query. i am getting an exception com.denodo.util.exceptions.InternalErrorException: [Teradata JDBC Driver] [TeraJDBC] [Error 1077] [SQLState HY000] executeQuery() cannot be us...

Answers: 2

teradata DENODO

Protocol to connect Denodo Scheduler from a third party
answered 27-09-2017 04:31:29 -0400

Hi Support, We are planning to centralize all the jobs i.e. Windows Task schduler , SQL and Denodo into one. We have planned to use VisualCron for this. Can you help us with the protocol(FTP/SCP/SMTP/POP3/IMAP/SSH/WebDav) to select to connect Denodo Sc...

Answers: 4

DENODO Denodo Scheduler 6.0

Common Table Expression (CTE) getting an error
answered 05-09-2017 09:01:20 -0400

Hi, i'm converting my CTE codes from SQL server to Denodo/VQL but i'm getting an error it say "QUERY VIRTUAL ERROR". I have a multiple CTE's in my script but when i use a left join in my final query using the result of CTE i'm getting an error and some...

Answers: 1

VQL simple condition VQL DENODO

Date Expression convert to decimal to varchar
answered 05-09-2017 06:27:00 -0400

Hi, I'm new to this forum and also just started to use Denodo. I'm using SQL Server and were converting some SQL codes to Denodo. I'm trying to convert this code below but i'm getting an error specially this portion cast(serialid as varchar)+cast(cast(...

Answers: 3


Creating an XML output view using the existing base/derived Views
answered 01-09-2017 09:29:26 -0400

How to Create an XML output using derived view ? for example: I have 3 base view Party, Party Address, Party Related Party. I will need to create an XML output, which needs to be published as SOAP Service. the structure should as below. <PartyServi...

Answers: 1

XML DENODO XML Data Source derived view XML request to response