Scalar User Defined Function Error

[mayank_gupta01]

Hi Friends,

I have Created User Function and I am using that function in my Stored Procedure, but when I am calling function with parameters,

it is showing error that

"feature not supported: field or table alias is not allowed as an input of table functions: line 197 col 48 (at pos 8792) at ptime/query/checker/check_call.cc:674 ",

I understood that I cant pass Table field in the Function, but I want to pass Table Field, it is Requirement in my Stored Procedure.

can anyone please tell me how to pass table fields in Function.

Thanks,

[former_member184768]

Hi Mayank,

The Scalar UDF is not very mature concept as of now. I am sure it will evolve soon, but currently there are quite many limitations.

I don't think you would be able to pass a table field as input to the function. As an alternative, you can loop though the table, get the column value to another scalar variable and pass that as the input.

Since you are internal to SAP, I'd recommend you to get in touch with the HANA development team directly to get more details on this.

Regards,

Ravi