DB2 to SAP HANA Migration -Db2 Translate ()  function in SAP HANA


DB2 Query  :

select PHONE_NUMBER,

(TRANSLATE(PHONE_NUMBER,,‘1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz()-/’)) as PHNE

from  “Phone_test


In above query where ever its find any letter from  this string ‘1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz()-/’ in phone number  It replace with Space like ‘ ‘


result s(Out put) :


Db2 Image.PNG

In SAP HANA there is no  Translate function  or similar function is not available , There is a work around using Regular Expression for similar scenario.

SAP HANA Query  with out put:

HANA Image.png

Thanks,

Asif

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply