WebIDE Procedure 中使用 Dummy table

WebIDE Procedure 中使用 Dummy table

如果直接在webide中新建procedure会报错，报错内容如下

The file requires “db://DUMMY” which is not provided by any file [8212001] at “xxxxxxxxxx.hdbprocedure”

下面的链接给出了正确解释
https://answers.sap.com/questions/12732453/dummy-table-in-webide-procedure.html
所以要新建一个 .hdbsynonym，新建的hdbsynonym将指向SYS.DUMMY

open code editor

{
  "xxxxxxxxxxxx.tables::DUMMY": {
    "target": {
      "object": "DUMMY",
      "schema": "SYS"
    }
  }
}

建完就可以直接在procedure里使用xxxxxxxxxxxx.tables::DUMMY表了

参考：https://blogs.sap.com/2017/01/06/synonyms-in-hana-xs-advanced-introduction/