DB2 to HANA Migration -DB2 Translate () function achivement in SAP HANA
DB2 to SAP HANA Migration -Db2 Translate () function in SAP HANA
DB2 Query :
(TRANSLATE(PHONE_NUMBER,”,‘1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz()-/’)) as PHNE
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) :
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: