Word_ext leads to syntax error in HANA stored procedures

Question

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

score 0 · Answer 1 · answered Sep 11 '17 at 23:44

0

"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.

answered Sep 11 '17 at 23:44

Lars Br.

9,949
2
15
29

So, that means word_ext is unavailable. What would be the substitute for it? – Muskaan Sep 12 '17 at 03:52
When you describe what `word_ext` should do for you then maybe somebody can answer this. – Lars Br. Sep 12 '17 at 09:17

Word_ext leads to syntax error in HANA stored procedures

1 Answers1