hdbtablefunction

SQL Functions (.hdbtablefunction )

This object type represents a database function.

Reference

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

SAP Help

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

Example Artifact Code

FUNCTION "MYSCHEMA"."hdb_view::OrderTableFunction" ()
	RETURNS TABLE (
		"Id" NVARCHAR(32),
		"CustomerName" NVARCHAR(500)
	)
	LANGUAGE SQLSCRIPT
	SQL SECURITY INVOKER AS
BEGIN

RETURN  SELECT "Id", "CustomerName" FROM "hdb_view::Item";

END;

Sample

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

• 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/hdbtablefunction 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/hdbtablefunction