on 06-25-2015 4:15 PM
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
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)
This syntax isn't available before SPS 09.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.