UrbanPro
true

Learn SAP HANA Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

SAP HANA SQL Stored Procedure Tutorial

Harsh Sharma
24/02/2018 0 0

A procedure is a unit/module that perform a specific task. This procedure can be combined to form larger programs. This basically forms the 'Modular Design'. A procedure can be invoked by another procedure which is called the calling program.

Procedures are re-useable processing block with a specific sequence of data transformation. The procedure can have multi-input/output parameters. The procedure can be created as read-only or read-write.

An SQL Procedure can be created at:

  • At Schema Level(Catalog Node)
  • At Package Level(Content Node)

Stored Procedure syntax in SAP HANA is as shown below:

SYNTAX

CREATE PROCEDURE  [()] [LANGUAGE ]    
        [SQL SECURITY ] [DEFAULT SCHEMA ]
        [READS SQL DATA [WITH RESULT VIEW ]] AS
        {BEGIN [SEQUENTIAL EXECUTION]
							
        END        
        | HEADER ONLY }
0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

SAP Analytics Cloud(SAC), or SAP Cloud Analytics
Hi All For all those who are currently working on SAP-BW,SAP-HANA,SAP-BO,SAP-Lumira,Design Studio,S/4HANA,BW/4HANA suggested to update SAP Analytics Cloud(SAC) a cloud version of BI from SAP Which is...

Sap Hana: How To Start Hana Studio & Start Hana System To Understand The Components And Views?
D-Click on SAP HANA Studio from the desktop. Use the login your user name and password which you got from the system adminstrator. Once login in to HANA system. Click on Add System if need to add...

Top 15 SAP HANA Interview Questions & Answers
1) Mention what is SAP HANA? Ans. SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication...

Differences Between SAP HANA & SAP S/4HANA
Some levels of confusion between SAP HANA and SAP S/4HANA still exist with the majority of the people these days. In this article, I would like to provide clarity for those who are wrestling with the differences...

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial
SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE Linux Enterprises Server and builds on C++ Language. SAP HANA Database can be distributed to multiple...
X

Looking for SAP HANA Training Classes?

The best tutors for SAP HANA Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn SAP HANA Training with the Best Tutors

The best Tutors for SAP HANA Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more