SAP HANA HDBTable定义Sequence语法
Sequence文件以.hdbsequence结尾
语法:
- Schema Name
schema= "MYSCHEMA";
- Increment Value(值为0则返回错误,默认值1)
increment_by= 2;
- Start Value
start_with= 10;
- Maximum Value(最大值30)
maxvalue= 30;
- No Maximum Value(使用此关键字Maximum Value失效 && 升序序列最大值:4611686018427387903 降序序列最大值:-1)
nomaxvalue= true;
- Minimum Value(最小值1)
minvalue= 1;
- No Minimum Value(使用此关键字Minimum Value失效 && 升序序列最小值:1 降序序列最小值:-4611686018427387903)
nominvalue= true;
- Cycles(达到最大最小值后,是否重启周期)
cycles= false;
- Reset by Query(重新生成数据库序列)
reset_by= "SELECT \"Col2\" FROM \"SCHEMA_ODATA001\".\"bu.odata001::table_odata001\""; depends_on=["bu.odata001::table_odata001"];
- Depends on(重新生成序列的决定性字段)
depends_on= ["<repository.package.path>::<MY_TABLE_NAME1>","<repository.package.path>::<MY_VIEW_NAME1>"];
- Schema Name
示例:
schema= "SCHEMA_ODATA001"; start_with= 10; maxvalue= 30; nomaxvalue=false; minvalue= 1; nominvalue=true; cycles= false; reset_by= "SELECT \"Col2\" FROM \"SCHEMA_ODATA001\".\"bu.odata001::table_odata001\""; depends_on=["bu.odata001::table_odata001"];
post SAP-Garson
原文链接:https://blog.csdn.net/qq_30797051/article/details/122687430文章来自于网络,如果侵犯了您的权益,请联系站长删除!