Q&A BY TAG 'Denodo stored procedure'
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
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
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
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
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
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
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