Real Time Analytics with SAP HANA

Calling PAL functions

To use PAL functions, you must do the following:

1. From within the SQLscript code, generate a procedure that wraps the PAL function.

   Any user granted with the AFLPM_CREATOR_ERASER_EXECUTE role can generate an AFLLANG procedure for a specific PAL function. The syntax is shown as follows:

   CALL SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE ('<area_name>', '<function_name>','<schema_name>', '<procedure_name>', <signature_table>);
   

   The following is a description of the preceding syntax:

   • <area_name>: This is always set to AFLPAL.
   • <function_name>: This is the PAL built-in function name.
   • <schema_name>: This is the name of the schema that you want to create.
   • <procedure_name>: This is the name of the PAL procedure (any name as per our choice).
   • <signature_table> ...