hdbprocedure - codbex/codbex-kronos GitHub Wiki

SQL Procedures (.hdbprocedure)

This object type represents a database procedure.

Reference

The information on how to develop the design-time data-persistence procedure model for a Kronos application.

SAP Help

https://help.sap.com/docs/SAP_HANA_PLATFORM/3823b0f33420468ba5f1cf7f59bd6bd9/93de88bf2c8242179647e40f958c24e5.html

Example Artifact Code

PROCEDURE "MYSCHEMA"."hdb_view::OrderProcedure" ()
   LANGUAGE SQLSCRIPT
   SQL SECURITY INVOKER
   --DEFAULT SCHEMA <default_schema_name>
   READS SQL DATA AS
BEGIN
   /*************************************
       Write your procedure logic
   *************************************/

      SELECT * FROM "hdb_view::Item";
END

Sample

https://github.com/codbex/codbex-kronos/tree/main/samples/hdb-procedure-simple

Modules

  • Data Structure Parser

https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/main/java/com/codbex/kronos/hdb/ds/parser/hdbprocedure

  • Processor

https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/main/java/com/codbex/kronos/hdb/ds/processors/procedure

Unit Tests

https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/parser/hdbprocedure https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/processors/procedure

Integration Tests

https://github.com/codbex/codbex-kronos/tree/main/integration-tests/engine-hdb/src/test/java/com/codbex/kronos/integration/tests/hdb/ds/itest/hdbprocedure