SQLScript HANA Database Procedure
Tutorials that teach this
- TutorialCreate HANA Stored Procedure and Expose as CAP Service Function (SAP HANA Cloud)
- TutorialAnonymous Blocks
- TutorialCreate Stored Procedures
- TutorialIntermediate Table Variables
- TutorialUse Table Variable Operators
- TutorialParallel Processing and Parameters
- TutorialUsing Table Variable Operators
- TutorialCreate an ABAP Managed Database Procedure (AMDP) and Analyze Its Performance
Docs explaining this concept
Prerequisites
- ConceptABAP Managed Database Procedures (AMDP)
- ConceptSAP HANA SQL API Usage
- ConceptSQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
- ConceptSAP HANA Cloud fundamentals
- ConceptSQL DDL and DML Statements (CREATE, INSERT, DROP)
- ConceptSAP HANA Graph Algorithms (Neighbors, Shortest Path)
- ConceptSAP HANA In-Memory Relational Database
Concepts that build on this
- ConceptAMDP Method Implementation
- ConceptSQLScript User Defined Libraries
- ConceptSQLScript Index-Based Cell Access for Table Variables
- ConceptSQLScript Table Variable Operators (INSERT, UPDATE, DELETE, SEARCH)
- ConceptSQLScript Scalar User-Defined Functions (UDFs)
- ConceptSQLScript Anonymous Blocks
- ConceptSQLScript Static Code Analysis (Security, Quality, Performance)
- ConceptSAP HANA Predictive Analysis Library (PAL)
- ConceptSAP HANA Stored Procedure Creation and Execution
- ConceptSQLScript Debugging with Breakpoints and Variable Inspection
- ConceptCDS Table Functions
- ConceptSQLScript Table Variables and Intermediate Tables