Table of Contents
1 About SAP HANA SQLScript......................................................4
1.1 Backus Naur Form Notation........................................................4
1.2 What is SQLScript? ..............................................................5
1.2.1 SQLScript Processing Overview..............................................6
1.3 Datatype Extension..............................................................8
1.3.1 Scalar Datatypes.........................................................8
1.3.2 Table Types............................................................ 8
1.4 Functional Extension.............................................................8
1.4.1 Create Procedure ........................................................9
1.4.2 SQLScript Procedure......................................................9
1.4.3 Default values for procedure parameters.......................................12
1.5 Procedure Calls................................................................12
1.5.1 CALL - Procedure Called From Client..........................................13
1.5.2 CALL - Internal Procedure Call.............................................. 13
1.5.3 Call with Named Parameters................................................14
1.6 Implementing Functional Logic.....................................................15
1.6.1 Table Variables.........................................................15
1.6.2 Binding Table Variables................................................... 15
1.6.3 Scalar Variables.........................................................16
1.6.4 Referencing Variables.................................................... 16
1.7 Calculation Engine Plan Operators...................................................16
1.7.1 Data Source Access Operators..............................................17
1.7.2 Relational Operators..................................................... 21
1.7.3 Special Operators.......................................................30
1.8 Imperative Extension............................................................34
1.8.1 Scalar Variables........................................................ 35
1.8.2 Variable Scope Nesting................................................... 36
1.8.3 Control Structures.......................................................39
1.8.4 Cursors.............................................................. 43
1.8.5 Dynamic SQL..........................................................48
1.9 Catalog Information.............................................................49
1.10 Best Practices for Using SQLScript..................................................51
1.10.1 Reduce Complexity of SQL Statements ........................................51
1.10.2 Identify Common Sub-Expressions...........................................52
1.10.3 Multi-level Aggregation................................................... 52
1.10.4 Understand the Costs of Statements .........................................52
2
P U B L I C
©
2012 SAP AG. All rights reserved.
SAP HANA SQLScript Reference
Table of Contents
