Question Re: Create HDB AFLLANG Procedure without fixed table type in Technology Q&A

Create HDB AFLLANG Procedure without fixed table type

Former Member — Thu, 29 Oct 2020 15:51:42 GMT

Hey everyone,

Following a video from SAP HANA Academy (https://youtu.be/QNe0qoPf-iw) I am currently creating procedures using XS Advanced for my application.

The video shows how to do exactly that but inside the parameters the structue of the input data has to be defined in advance like this:

{ 
  "area" : "AFLPAL", 
  "function" : "AUTOARIMA", 
  "parameters" : [ 
    { 
      "type" : "myapp.db::PAL.TTData", 
      "direction" : "IN" 
    },
...

However, I would like to have a procedure where the user can input any kind of table (i.e. arbitrary number and type of columns). For most PAL algorithms that should not be a problem. Of course the parameter table has to have a fixed structure, but not the input table.

Can I somehow do that using HDB AFLLANG procedures as well?

Thanks a lot in advance!

Best regards,

Alex

Re: Create HDB AFLLANG Procedure without fixed table type

Kai_Mueller — Fri, 20 Nov 2020 07:59:09 GMT

Hello Alex,

by checking the documentation it seems not to be possible. To my understanding a new procedure is created wrapping the AFL procedure. Since procedures need exact parameters, there is no option to be flexible here.

The AFL procedures can be flexible since they are defined in the C++ code.

Best regards, Kai

Re: Create HDB AFLLANG Procedure without fixed table type

Former Member — Mon, 23 Nov 2020 08:35:47 GMT

Thanks for the answer, Kai!