Create HDB AFLLANG Procedure without fixed table type

[former_member710183]

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

[Kai_Mueller · Accepted solution]

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

[former_member710183 · Accepted solution]

Thanks for the answer, Kai!