Creating SQLScript Stored Procedures in SAP HANA
Tutorials that teach this
- Tutorial Scheduling SAP HANA Cloud Tasks
- Tutorial Debugging Stored Procedures
- Tutorial Create Stored Procedures
- Tutorial Create Scalar User Defined Functions
- Tutorial Use a Cost Function to Calculate Shortest Path
- Tutorial Convert Oracle-to-SAP HANA with Advanced SQL Migration Tool
- Tutorial Anonymous Blocks
- Tutorial Parallel Processing and Parameters
- Tutorial Use Index-Based Cell Access
- Tutorial Migrate Records in Related Tables Using Stored Procedures
- Tutorial Use Table Variable Operators
- Tutorial Create Stored Procedures
- Tutorial Calculate Shortest Path Using a GRAPH Procedure
- Tutorial Using Index Based Cell Access
- Tutorial Using Table Variable Operators
- Tutorial Creating SQLScript User Defined Libraries
- Tutorial Create HANA Stored Procedure and Expose as CAP Service Function (SAP HANA Cloud)
- Tutorial Create Scalar User Defined Functions
- Tutorial Create Database Objects with SAP HANA Database Explorer
- Tutorial Debugging Stored Procedures
- Tutorial Create an ABAP Managed Database Procedure (AMDP) and Analyze Its Performance
- Tutorial Anonymous Blocks
- Tutorial Intermediate Table Variables
- Tutorial Intermediate Table Variables
- Tutorial Parallel Processing and Parameters
- Tutorial Create a User, Tables and Import Data Using SAP HANA HDBSQL
- Tutorial Create SQLScript User Defined Libraries
- Tutorial Migrate Records in Related Tables Using Stored Procedure
Prerequisites
- Concept SQL Nested Subqueries (WHERE IN SELECT)
- Concept Using the SQL Console in SAP HANA Cloud Central
- Concept SQL Aggregate Functions (COUNT, MAX, GROUP BY)
- Concept SAP HANA Database Artifacts
- Concept Using the Procedure Editor in SAP HANA XS Advanced
- Concept Building an HDB Module in SAP HANA XS Advanced
- Concept SAP HANA XS Advanced Cockpit Administration
- Concept SQLScript Table Variables (DECLARE ... TABLE LIKE)
- Concept SQL INSERT INTO ... SELECT Statement
- Concept SAP HANA Database Explorer
- Concept Defining Column Tables with SQL in SAP HANA
- Concept Converting Between In-Memory and Extended Tables in SAP HANA Dynamic Tiering
- Concept Browsing and Exploring Catalog Objects in SAP HANA Cloud
- Concept SAP HANA XS Advanced Node.js Applications
- Concept Schema Creation and Management in SAP HANA
- Concept Shortest Path Algorithm in SAP HANA GraphScript
- Concept SAP HANA Database Project in BAS
- Concept Defining Output Parameters in SQLScript Procedures
- Concept Creating and Removing Extended Storage in SAP HANA Dynamic Tiering
Concepts that build on this
- Concept Defining Output Parameters in SQLScript Procedures
- Concept AMDP Method Implementation
- Concept Foreign Key Constraints and Extended Table Conversion in SAP HANA Dynamic Tiering
- Concept Hierarchy Functions for SAP HANA Anonymized Views
- Concept SQL INSERT INTO ... SELECT Statement
- Concept Visualizing Query Execution Plans for SAP HANA Calculation Views
- Concept SQLScript Debugger in SAP HANA Database Explorer
- Concept Expensive Statements Trace in SAP HANA
- Concept Index-Based Cell Access in SQLScript Table Variables
- Concept SQLScript User Defined Libraries
- Concept SQLScript Table Functions in SAP HANA
- Concept SQLScript Code Analysis (Security, Quality, Performance)
- Concept SQLScript Anonymous Blocks (do begin...end)
- Concept Scalar User Defined Functions (UDF) in SAP HANA
- Concept Table User Defined Functions in SAP HANA
- Concept SQL Date Functions (ADD_YEARS, CURRENT_DATE) for Filtering
- Concept Scheduling SQL Stored Procedures with CREATE SCHEDULER JOB in SAP HANA
- Concept MapReduce Operations in SAP HANA SQLScript
- Concept SQLScript Code Coverage Analysis
- Concept SQLScript Table Variable Operators (INSERT, UPDATE, DELETE, SEARCH)
- Concept Cost Function (Lambda) in SAP HANA Graph Shortest Path
- Concept SQLScript Table Variables (DECLARE ... TABLE LIKE)
- Concept Parallel Processing with Table Variables in SAP HANA SQLScript
- Concept Creating GraphScript Procedures in SAP HANA