Menu
Simba Technologies
Simba Technologies

SimbaEngine X SDK 10.1.3
Developing Drivers for Data Stores Without SQL

Stored Procedures

This feature is available in the C++ and the Java SDK. Instead of calling a SQL statement on the data store, an application can call a stored procedure. A stored procedure is an operation that allows the DSI to take advantage of internal functions or extended non-SQL functionality that the data store may support. Custom functions that can be implemented inside these stored procedures may allow access to data that is not stored in standard relational tables.

Stored Procedures in the C++ SimbaEngine X SDK

The C++ SimbaEngine X SDK provides the following DSI API classes to support stored procedures:

  • DSIExtProcedure
  • The base class for DSII stored procedures. Implement the pure virtual functions to provide functionality. This class provides the framework for custom stored procedures, which are returned to SQLEngine via DSIExtSqlDataEngine::OpenProcedure().

  • DSIExtMetadataHelper

    We recommend that you implement the virtual function GetNextProcedure() to allow the SDK to get a list of defined procedures. Although this is optional, it is recommended.

  • DSIExtSqlDataEngine
  • Use this to implement OpenProcedure(), same as OpenTable().

Note:

The Codebase sample shows many examples of the different ways that stored procedures can be used, and is an excellent reference.

Stored Procedures in the Java SimbaEngine X SDK

The Java Simba SQLEngine provides the following DSI API classes to support stored procedures:

StoredProcedure
The base class for DSII stored procedures. Implement the pure virtual functions to provide functionality. This class provides the framework for custom stored procedures, which are returned to SQLEngine via DSIExtSqlDataEngine::OpenProcedure().

IMetadataHelper
Use this to support GetNextProcedure() to allow the SDK to get a list of defined procedures.

SqlDataEngine
Use this to implement OpenProcedure(), same as OpenTable().