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

How to search for / list in Denodo columns (of a view) that make use of a certain function?
answered 25-03-2021 08:37:01 -0400

How can I search for / list in Denodo all columns (of a view) that make us of a certain function? For example, I would like to list all columns that make use of "getdaysbetween"?

Answers: 1

Denodo stored procedure Metadata Catalog

Error while creating a project in Eclipse
answered 04-01-2021 06:29:09 -0500

Hi I'm trying to create a new project in eclipse after installing the denodo4e software successfully, but its giving me an error saying wizard cannot be started. Please help me on this as my teams development activities are getting delayed because of...

Answers: 1

Denodo stored procedure Custom 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

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