hdbtable - codbex/codbex-kronos GitHub Wiki
Tables (.hdbtable)
This object type represents a database table.
Reference
The information on how to develop and transform a design-time table resource into a table database object for a Kronos application.
SAP Help
https://help.sap.com/docs/SAP_HANA_PLATFORM/cc2b23beaa3344aebffa2f6e717df049/89cbf999e6004be3a5324b8f9ef0c53f.html https://help.sap.com/docs/SAP_HANA_PLATFORM/3823b0f33420468ba5f1cf7f59bd6bd9/453d48e28f6747799546236b4b432e58.html
Sample Hana XS Classic Syntax
table.schemaName = "MYSCHEMA";
table.tableType = COLUMNSTORE;
table.columns = [
{name = "Col1"; sqlType = VARCHAR; nullable = false; length = 20; comment = "dummy comment";},
{name = "Col2"; sqlType = INTEGER; nullable = false;},
{name = "Col3"; sqlType = NVARCHAR; nullable = true; length = 20; defaultValue = "Defaultvalue";},
{name = "Col4"; sqlType = DECIMAL; nullable = false; precision = 2; scale = 3;}];
table.indexes = [
{name = "MYINDEX1"; unique = true; indexColumns = ["Col2"];},
{name = "MYINDEX2"; unique = true; indexColumns = ["Col1", "Col4"];}];
table.primaryKey.pkcolumns = ["Col1", "Col2"];
Sample Hana XS Advanced Syntax
COLUMN TABLE "MYSCHEMA::MYTABLE" (
"ID" INTEGER DEFAULT 555, "NAME" NVARCHAR(256),
"ACTIVE" TINYINT,
"COUNTRY" NVARCHAR(256),
PRIMARY KEY ("ID") )
Parser Specific Details
The parser does not allow duplicate properties.
The order of the table's properties, as well as column's and index's properties is not taken into account when table definition is parsed. Exception will be thrown if a property is defined more than once in the *.hdbtable file. Also, additional exception will be thrown in case a mandatory field is missing.
Sample
https://github.com/codbex/codbex-kronos/tree/main/samples/hdb-hdbtable-simple
Modules
- ANTLR Parser
https://github.com/codbex/codbex-kronos/tree/main/modules/parsers/parser-hdbtable/src/main
- Data Structure Parser
- Processor
Unit Tests
https://github.com/codbex/codbex-kronos/tree/main/modules/parsers/parser-hdbtable/src/test https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/parser/hdbtable https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/processors/table