Q&A BY TAG 'STORED PROCEDURES'

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

Stored Procedure- SP
answered 06-06-2017 05:54:10 -0400

I assume to do procedural programming in denodo we need to use Java. Is there any option to use Ansi SQL / PLSQL kind of Procedural langauage in denodo ?

Answers: 1

Stored Procedures

Calling a Stored Procedure within another Stored Procedure
answered 25-05-2017 04:43:19 -0400

I want to know if I can call a Stored Procedure from another Stored Procedure. For example I want to Generate the Statistics for all Derived Views in a particular VDP database. The "GENERATE_STATS" stored procedure uses the View name as a parameter The...

Answers: 1

VQL Stored Procedures

Maven Integration with Denodo4E plugin
answered 19-04-2017 07:51:06 -0400

Can we integrate Maven build management with the Denodo4E plugin ? I am trying to upload dependencies to Nexus repository so they can be linked in the project using Maven. When deploying the Denodo project, the plugin doesn't recognize the dependencie...

Answers: 3

Stored Procedures Custom Functions Denodo4E deploy

Choosing the fields returned in stored procedure call CATALOG_VDP_METADATA_VIEWS
answered 27-03-2017 08:51:18 -0400

Is there a way to limit the fields returned in the Stored Procedure call CALL CATALOG_VDP_METADATA_VIEWS . For example, I only need the following fields from this call: DATABASE_NAME: name of the database that the view of the field belongs to. VIEW_NA...

Answers: 1

meta data Stored Procedures

UsedBy.. not working for some view
answered 03-01-2017 04:19:46 -0500

I want to see the list of the views using a particular view, for this im trying to use the UsedBy.. dialog available but it doesn't show any output(Just Blank). this is happening for few base views only, for remaining either it shows the output or it s...

Answers: 1

VDP Stored Procedures

Bulk insert into Temporary or Materialized table
answered 09-09-2016 09:46:34 -0400

We are building custom procedure which would based on parameter create temporary or materialized table after applying filter, business logic on few tables. As we are using "environment.executeUpdate()" method to populate temporary\materialized table, i...

Answers: 1

Stored Procedures

Use Custom Stored Procedure to connect to a VDP Data Source
answered 06-07-2016 07:05:02 -0400

Hi, Is it possible to write a custom stored procedure in java, that uses the connection of one of the VDP data sources? For example, have the java stored procedure run a query on an object that doesnt exist as a base view in Denodo? Thanks!

Answers: 1

data sources Stored Procedures connection

Show tables with data type
answered 18-04-2016 18:17:38 -0400

Hi there, Are there any SP's native to Denodo which would give me the name of an object, the type (base view, etc...) and the data type of the table, similar to how sys.columns works for MSSQL Server? I fired off the Catalog_Views SP, but don't see al...

Answers: 2

Stored Procedures

nest function fails when field contains null as values
answered 21-09-2015 12:34:22 -0400

Hi, I Have a problem while returning an array over a set of fileds where some of them might contain null (This is a valid value) inside a stored procedure In the stored procedure i have the return value as below new StoredProcedureParameter( "ord...

Answers: 1

ARRAY Stored Procedures

Database stored procedures
answered 03-07-2015 10:09:38 -0400

I was trying out Denodo Express (5.5) and see that they have added graphical support for stored procedures. I found through testing that I could create a base view from an Oracle function which took in a mandatory input variable and returned an inte...

Answers: 4

VDP Stored Procedures