Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to use loop and if condition inside AMDP

Former Member

‎05-18-2016 12:46 PM

0 Kudos

Hello Expert,

In AMDP how we can use the loop and if condition.

Can someone please help me with one small example.

Best Regards,

Kailash

3 REPLIES 3

thomasgauweiler
Active Participant

‎05-18-2016 12:52 PM

0 Kudos

Have you tried to use google to search for SAP HANA SQL Script? It will lead you to http://help.sap.com/hana/SAP_HANA_SQL_Script_Reference_en.pdf

Former Member
In response to thomasgauweiler

‎05-18-2016 1:11 PM

0 Kudos

Hello Thomas,

Thank you for your reply.

The link is for the hana procedure call. But I want to do the looping in AMDP. If it is possible, then please help me.

Best Regards,

Kailash

thomasgauweiler
Active Participant
In response to thomasgauweiler

‎05-18-2016 1:17 PM

0 Kudos

Hi Kailash,

The document defines all statements usable within a database procedure incuding "Control Structures" like IF, WHILE etc.

But be warned: do not try to loop over single reords of result sets. This can slow down your procedure dramatically.

Best Regards, Thomas