hdbscalarfunction - codbex/codbex-kronos GitHub Wiki

SQL Functions (.hdbscalarfunction )

This object type represents a database function.

Reference

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

SAP Help

https://help.sap.com/docs/SAP_HANA_PLATFORM/52715f71adba4aaeb480d946c742d1f6/985c78b07f304c17a660e3ba202dd70d.html

Example Artifact Code

FUNCTION "MYSCHEMA"."hdb_functions::OrderScalarFunction" (im_price decimal(15,2), 
                 im_discount decimal(15,2) ) 
	RETURNS result decimal(15,2)
	LANGUAGE SQLSCRIPT
	SQL SECURITY INVOKER AS
BEGIN
result := :im_price - ( :im_price * :im_discount );
END;

Sample

https://github.com/codbex/codbex-kronos/tree/main/samples/hdb-scalarfunction-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/hdbscalarfunction

• Processor

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

Unit Tests

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

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/hdbscalarfunction