Stored procedures in sap hana

[Former Member]

i want step by step process guide to learn stored procedures in sap hana

Thanks in advance

[chandan_praharaj · Accepted solution]

http://help.sap.com/hana_one/html/_hprocedural_statements.html

In addition to above inputs,  please check the above link guide from SAP.

[SergioG_TX]

check out the developer guide - there are two types design time (suggested) and run time.

design time stored procedures (.hdbprocedure) are easy to transport.

stored procedures are reusable database objects to perform CRUD operations against a database table or set of tables.

create a HANA or XS project - create a file .hdbprocedure and follow the developer guide.

there may be syntax issues you will encounter... check out the sql script guide.

good luck

[patrickbachmann]

Also if you want visual hands on tutorial; if you google Thomas Jung HANA procedures you will find a bunch of good videos he posted on youtube.

-Patrick

[Former Member]

thankyou