cancel
Showing results for 
Search instead for 
Did you mean: 

Regular Expression

Former Member
0 Kudos

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?f...

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)

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

This syntax isn't available before SPS 09.

Former Member
0 Kudos

Dear Martin,

I used SPS 09.

Or do I have to Update the HANA Studio, too?

Former Member
0 Kudos

I executed your example command in my SPS 09 environment with success. I used a recent SAP HANA Studio, so it is worth a try if the problem is fixed with a new SAP HANA Studio version.

bjrn_hippenstiel
Explorer
0 Kudos

Hi Thomas,

you wrote that you have HANA Version 1.00.85...

Doesn't that mean that you are still on SPS08?

Regards

Björn

Former Member
0 Kudos

In HANA Studio I see the Version 1.00.85.03.400544

But our Admin said it is on SPS 09.

So I dont know ...

Former Member
0 Kudos

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

bjrn_hippenstiel
Explorer
0 Kudos

me too

Answers (0)