Day 9 — SAP HANA Procedures

What is a Procedure in SAP HANA? Why do we use it?

A Procedure is a reusable program written in SQLScript that executes multiple SQL statements together inside the SAP HANA database. 1. What is a Procedure? a. A reusable SQLScript program. b. Executes inside the database. c. Can contain multiple SQL statements. d. Supports business logic. e. Can return output values. 2. Why Do We Use Procedures? a. Improves performance. b. Reduces network communication. c. Executes complex business logic. d. Reuses the same code multiple times. e. Makes applications faster. 3. Features of Procedures a. Supports Variables. b. Supports IF conditions. c. Supports Loops. d. Supports Exception Handling. e. Supports Input and Output Parameters.

• A customer places an order. • The Procedure checks stock availability. • Calculates GST. • Applies discounts. • Saves the order in the database. • Returns "Order Created Successfully."

1. What is a Procedure? 2. Why do we use Procedures? 3. What language is used to create Procedures? 4. Can Procedures contain loops? 5. Give one real-time example.