Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Regular Expression

I tried to make an SQL Statment with RegEx, like in thouse examples:

http://help.sap.com/saphelp_hanaplatform/helpdata/en/a2/f80e8ac8904c13959c69bfc3058f19/content.htm

http://help.sap.com/saphelp_hanaplatform/helpdata/en/b4/0d483dd34d47aa9cc89b4d8a6e617e/content.htm?frameset=/en/a2/f80e8ac8904c13959c69bfc3058f19/frameset.htm&current_toc=/en/2e/1ef8b4f4554739959886e55d4c127b/plain.htm&node_id=81

I have the HANA Version: 1.00.85.03.400544

But I get the followning Errors:

Could not execute 'SELECT SUBSTR_REGEXPR('([[:digit:]])([[:digit:]])([[:digit:]])' IN '20140401') ...' in 1 ms 650 µs .

SAP DBTech JDBC: (at 74): sql syntax error: incorrect syntax near "IN": line 1 col 74 (at pos 74)

Could not execute 'SELECT * FROM OITM WHERE "ItemName" LIKE_REGEXPR 'Soft%'' in 1 ms 694 µs .

SAP DBTech JDBC: (at 40): sql syntax error: incorrect syntax near "LIKE_REGEXPR": line 1 col 40 (at pos 40)

Tags:
replied

In this case I would believe SAP HANA Studio, so it is SPS 08.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question