Latest Activity

code

Creating a view from a Denodo Stored Procedure

Hello, Is it possible to create a view using a Denodo Stored Procedure or incorporate a Denodo Stored Procedure in an existing view. I need to count the total number of rows in the output of a view and then take that total count and include it in that ...

Stored Procedure

code

Delegate SQL Sentence as Sub Query not passing to source

Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...

subquery Execution plans Stored Procedure derived view

code

Joining View Created From Stored Procedure to View Created from "Create from query" option - Not Working

Hello, Can a view created from a stored procedure be joined with a view created from the "Create from query" option? I have a report that runs perfectly now. The report is generated from a view created from a stored procedure joined to a view created t...

baseview created from query Stored Procedure

code

Base View from query

Hi Team, Denodo 5.5 How to create a Base View from Query on stored procedure 'element_metadata()' Please tell. I also intend to use interpolation variables. Thanks.

Query Stored Procedure

code

Error executing CREATE_REMOTE_TABLE stored procedure

I am getting the error below while executing the CALL CREATE_REMOTE_TABLE () stored procedure. Finished with error: error invoking stored procedure: Stored procedure 'create_remote_table' not found Any ideas or anyone encounter this earlier?

Denodo stored procedure remote table Stored Procedure

code

How to execute a dynamic sql or a stored procedure for a view?

Hi, I used to create a stored procedure in cisco information server(CIS) to produce dynamic sql query. For example, few input params for query columns. However, I am told that I need to wrtie Java code for stored procedure in Denodo. Is it ture? I am ...

Quary execution Stored Procedure

code

get_source_table

how to repliacte functionality of get_source_table stored procedure in VDP 5.5 in VDP 5.5 :: select * from get_source_table() Error executing sentence: Stored procedure 'get_source_table' not found

Stored Procedure

code

Calling a Custom Stored Procedure from a Custom Stored Procedure

I want to know if it is possible to calling an existing custom stored procedure from a new custom stored procedure. I have tried calling a custom function from custom stored procedure and it works well.

custom Stored Procedure

code

Make input parameters optional when importing a SQL Stored Procedure

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...

REST API Denodo Stored Procedure

code

Availability of GET_ELEMENTS

Hi Team, Do GET ELEMENTS stored procedure works in all Denodo versions ? I use below: Denodo Platform 5.5 Denodo Platform 6.0 Denodo Express 6.0 Of these i get results only in Denodo Platform 6.0 In others I get error message: "Error execu...

Stored Procedure