Executing VQL statements from a stored procedure

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 18 May 2020
Tags: Stored procedures VQL

Download document

You can translate the document:

Goal

This document describes how to execute VQL statements from a stored procedure.

Content

One of the main functionalities when developing a stored procedure is the possibility of executing a VQL statement to execute queries and perform CRUD operations on the Virtual DataPort database where the stored procedure is being executed.

To do so the stored procedures have a method:

public void initialize(DatabaseEnvironment environment)

that is executed when the stored procedure is initialized and can be implemented to obtain a reference to a
DatabaseEnvironment object. The database environment object represents the VDP database where the stored procedure is being executed and it provides the following methods:

  • ResultSet executeQuery(java.lang.String query): to execute SELECT statements.

  • int executeUpdate(java.lang.String query): to execute CRUD operations.

More information about these methods and the DatabaseEnvironment object is available in the API documentation:

References

Virtual DataPort Developer Guide: Developing Stored Procedures

Denodo Virtual DataPort 8.0.0 AP

Questions

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

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training