Latest Activity

code

Other way to create function or procedure?

Is the there a way to create custom function without using without third party app such as eclipse?

Function Stored Procedures

code

Stored Procedure- SP

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 ?

Stored Procedures

code

Calling a Stored Procedure within another Stored Procedure

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...

VQL Stored Procedures

code

Maven Integration with Denodo4E plugin

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...

Stored Procedures Custom Functions Denodo4E deploy

code

Choosing the fields returned in stored procedure call CATALOG_VDP_METADATA_VIEWS

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...

meta data Stored Procedures

code

UsedBy.. not working for some view

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...

VDP Stored Procedures

code

Bulk insert into Temporary or Materialized table

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...

Stored Procedures

code

Use Custom Stored Procedure to connect to a VDP Data Source

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!

data sources Stored Procedures connection

code

Show tables with data type

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...

Stored Procedures

code

nest function fails when field contains null as values

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...

ARRAY Stored Procedures