Word_ext leads to syntax error in HANA stored procedures

597 views Asked by At

I expect the output to be A but the invalid function name error is thrown. The syntax appears to be correct as checked on the internet.

SELECT word_ext('A,B',1,',') FROM dummy
1

There are 1 answers

2
Lars Br. On

"Because the Internet said so"? Well, in this case, the internet is wrong, since word_ext neither is a standard SQL function nor one that SAP HANA provides.

The only reference to word_ext in the rather broad context chain of "SAP HANA" -> "SAP" -> "Data processing" I could find was in relation to a specific string manipulation function in SAP Data Services, an ETL tool.