To create procedure like we create .hdbprocedure in sap HANA

[jyotiranjanrath-sap]

Hi,

I was trying to create project using cds-dbm. I was able to create tables and view using CAP. However I also wanted to create procedures and function like we create .hdbprocedure and .hdbfunction in sap hana. Currently I am unable to find a way to create design time artifacts for procedures or functions and then to deploy it.

Is there a way to create and deploy this?

[mikezaschka]

Hi @jyotiranjanrath-sap,

sorry for answering late.
By default PostgreSQL does not support design time files for procedures (or any other fragments).
I am in the process of developing and releasing version 2 of cds-dbm. This will introduce a manual changelog based approach, which makes is possible to manually add .sql files as part of the changelog and thus adds support for creating and deploying native DB fragments.
A release of version 2.0 will happen within the next weeks.