Q&A BY TAG 'Denodo stored procedure'

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

Create view from the predefined Denodo stored procedures
answered 25-03-2020 12:48:30 -0400

How do you create a base view from the predefined/out-of-the-box Denodo stored procedures? I do not see them listed in the element tree although I am able to return results as well as list the procedures via the VQL shell query.

Answers: 3

Denodo stored procedure

List Procedure Jar Dependencies
answered 04-02-2020 09:08:35 -0500

Hi I am looking for denodo metadata views which can give relationship of user defiened stored procedures and Jars with version. I have used the "LIST JARS" catalog function. This function returns the JAR name and stored procedure or functions of that ...

Answers: 1

metadata store Denodo stored procedure Stored Procedures

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

Custom Store Procedure Error
answered 07-08-2019 22:44:05 -0400

Hi guys, I want to ask something. When I already create Denodo Extension Project in Java, after that i still have an issue regarding "The type java.lang.Object cannot be resolved". Description Resource Path Location Type The project was not built sin...

Answers: 2

Denodo stored procedure java custom

Example Denodo Stored Procedure to interact with SQL Server Stored Procedure
answered 27-12-2018 16:37:43 -0500

Hi, Denodo Where can I find some example denodo stored procedures to takes some input parameters to feed into an MS SQL server stored procedure(not regular SQL scripts) that does some analysis and returns a table, for joining with other denodo base vi...

Answers: 3

VQL Denodo 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

Custom Stored Procedure with default parameter
answered 01-08-2018 15:49:02 -0400

Hi, in java we created a custom stored procedure having a few input parameters. new StoredProcedureParameter("input_database_name", Types.VARCHAR, StoredProcedureParameter.DIRECTION_IN), new StoredProcedureParameter("input_view_name", Types.V...

Answers: 1

Denodo stored procedure custom Parameter

Accepting json data as input in Denodo stored procedure
answered 18-06-2018 11:19:48 -0400

Hi, My requirement is to develop a stored procedure which accepts application/json data as input and output some result. Later point of time on top of this stored procedure i need to create a REST service and returns JSON response.I am aware of GET RE...

Answers: 3

Denodo stored procedure