In the articles SAP HANA Procedure - Old Wine in New Bottle and Create Procedure in HANA we explained the basic features and functionalities of Procedures in SAP HANA.
Now, we will provide various examples of procedures in HANA.
Now, we will provide various examples of procedures in HANA.
Note: You can also browse the examples from index in the left side of this page.
Example 1: How to Use Table Type in SAP HANA Procedure
This example explains how to use table type in procedure and how to send output using table type.
This example explains what scalar variable in HANA is and how to declare, initialize and use them.
Example 3: Variable Scope Nesting in Procedure
SQLScript supports local variable declaration in a nested block. In this example we have explained how visibility and scope works.
Example 4: IF-ELSE Logic in Procedure
This example shows how to declare and use conditional operator (If-Else) in procedure.
Example 5: For Loop in Procedure
In this example we have explained the use of For loop, BREAK and CONTINUE.
Example 6: Use of Array in Procedure
This examples show how to declare, initialize and use Array in procedure. It also shows how UNNEST function works on Array.
Example 7: Dynamic Filter in HANA
HANA supports dynamic filter. This example shows how to implement dynamic filtering using APPLY_FILTER method.
Example 8: Exception Handling in HANA
This example explains the use of Exception Handling in procedure.
Example 9: How to Use SIGNAL to Throw Exception
In this example we have shown how to explicitly raise an exception from within your procedures using SIGNAL.
Example 10: How to Use RESIGNAL to Throw Exception
The RESIGNAL statement raises an exception on the action statement in exception handler. This example shows the use of RESIGNAL and how it is different from SIGNAL.
Example 11: Cursor in HANA
This example explains how to implement cursor in procedure. It also explain the various performance aspect of cursor.
Did not find what you were looking for?
If you want any specific example to be included in our list, please leave a comment or contact us at admin@saphanatutorial.com
Hi to all. The blog is really good and the above information is helpful to me. Thank you so much.
ReplyDeletejavascript training in chennai
javascript training in Porur
javascript training in Adyar
javascript training in T Nagar
core java training in chennai
C C++ Training in Chennai
Appium Training in Chennai
JMeter Training in Chennai