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>: This is a user-defined table variable. The table contains records to describe the position.

2. Call the procedure, for example, from an SQLscript procedure.

   After generating a...