Q&A BY TAG 'STORED PROCEDURE'
Need help creating a Base View from a SQL Server Stored Procedure
answered
18-08-2020 08:14:29 -0400
I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...
Answers:
3
Creating A Base View On Snowflake Stored Proc/ Multiple Statements
answered
22-07-2020 18:04:16 -0400
Hi, I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs. What I am trying to do is: Run the stored proc Capture the result of the proc The Snowflake statments are like these: -----CALLING ...
Answers:
1
Create base view from exist stored procedure at teradata source
answered
08-06-2020 08:43:40 -0400
Hi, please I have stored procedure exist at teradata source and I need to create baseview using this stored procudre , so I tried to make base view by using create from sql query and type call pocedureName() but error appears " [Teradata Database] [Ter...
Answers:
1
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
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
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
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
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
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