Q&A BY TAG 'Stored Procedure'

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

Provide access to SINGLE view to MULTIPLE roles
answered 05-11-2019 08:54:33 -0500

Hello team, As we know, in Denodo we can give a view level access for a role. I have a situation where I need to give access to a SINGLE view to MULTIPLE roles(around 30). The procedure is to select each role, click on edit in the database and give wh...

Answers: 3

Denodo stored procedure database assign privilages Base View descrptions Access and Role Stored Procedure VQL Role Role and User Management Roles Users

Creating a view from a Denodo Stored Procedure
answered 19-08-2019 03:04:04 -0400

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

Answers: 4

Stored Procedure

Delegate SQL Sentence as Sub Query not passing to source
answered 23-07-2019 01:57:09 -0400

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

Answers: 1

subquery Execution plans Stored Procedure derived view

Joining View Created From Stored Procedure to View Created from "Create from query" option - Not Working
answered 17-07-2019 09:46:41 -0400

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

Answers: 5

baseview created from query Stored Procedure

Base View from query
answered 31-01-2019 05:42:13 -0500

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.

Answers: 2

Query Stored Procedure

Error executing CREATE_REMOTE_TABLE stored procedure
answered 28-11-2018 16:55:23 -0500

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?

Answers: 1

Denodo stored procedure remote table Stored Procedure

How to execute a dynamic sql or a stored procedure for a view?
answered 05-07-2018 13:02:27 -0400

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

Answers: 3

Quary execution Stored Procedure

get_source_table
answered 29-03-2018 08:15:13 -0400

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

Answers: 3

Stored Procedure

Calling a Custom Stored Procedure from a Custom Stored Procedure
answered 02-01-2018 11:10:58 -0500

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.

Answers: 2

custom Stored Procedure

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