Creating an SQLScript Procedure

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Create an SQLScript procedure

Describing the Structure of a Database Procedure

In a database management system (DBMS), a stored procedure is a set of SQL statements with an assigned name that is stored in the database for repeating tasks on top of fast changing real-time data processing.

A stored procedure is used to consolidate and centralize data intensive logic. It can accept input parameters and return output parameters. There are scalar- and tabular outputs possible. Stored procedures next to calculation views play a key role in the strategic goal of pushing the processing logic to the database through the usage of procedure plans and the optimizer.

At design time, it is defined via the .hdbprocedure artifact.

Procedure Name

Interface (Input and Output Parameters)

Header Properties

Script Body

Creating an SQLScript Procedure

Log in to track your progress & complete quizzes