SAP SQLScript Development Guide

Overview

SQLScript is SAP HANA's procedural extension to SQL, enabling complex data-intensive logic execution directly within the database layer. It follows the code-to-data paradigm, pushing computation to where data resides rather than moving data to the application layer.

Key Characteristics

• Case-insensitive language
• All statements end with semicolons
• Variables use colon prefix when referenced (:variableName)
• No colon when assigning values
• Use DUMMY table for single-row operations

Two Logic Types