SAP HANA SQLScript · Procedures, Functions & Libraries

What must the return of a table User-Defined Function (UDF) look like, and what's its default security mode?

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Procedures, Functions & Libraries

A colleague wants to hide business logic by shipping a procedure WITH ENCRYPTION. What must you warn them about?

Inside another procedure/block, you write statustexts(iv_langu => 'DE', et_result => lt_x); with no CALL. Valid?

Calling a procedure, you pass a brand-new variable name to an OUT table parameter that was never declared. Error?

Can a SQLScript procedure call itself? Since which version, and what's the limit?

You need a read-only subroutine whose result you can join inside a SELECT. Procedure or function — and why?

Which SQL can a scalar UDF contain, and what may it call?

Start learning today

Free to start — download the app or use it in your browser.