How to use non-select(insert, delete) statement inside HANA UDF?

[Former Member]

Hi,

As per HANA document, UDF (User defined function) is read only, but client’s requirement is preserve calculated value into temporary table.

Example: Increase salary by 10% for each employee and store it in temporary table, but function return total increased salary as per department.

Any workaround is available for non-select(insert, delete) statement inside HANA UDF.

Thnaks,

Somnath A. Kadam

[lbreddemann]

As you correctly  read in the documentation, UDFs have to be readonly.

Please expand on your customer requirements that make it necessary to have a data change-enabled UDF.

Why can't you just use a procedure to perform the salary increase?

Procedures can return table types or write into a temp. table, whatever tickles your fancy.

- Lars