IBM Mainframe Forum

Hi ,
could you please help me to prepare a select query to mask the phone no
my requirement is to mask the phone no except last 4 digits
please note that phone nos are not fixed length
Table column(PHONE_NO) having values like below
94758365494
0438278475859574
8428746857733774443

expected output sud be like below
xxxxxxx5494
xxxxxxxxxxxx9574
xxxxxxxxxxxxxxx4443

thanks in advance

Hello,

This is my example table;

Where the columns are;
RKNAM1 = First name
RKNAM2 = Surname
RKFONE = Phone number

The below SQL adds a MASK column, based on the RKFONE column;

SELECT CUSTOMERS.*,
REPEAT('X', (LENGTH(TRIM(RKFONE))-4)) ||
SUBSTRING(TRIM(RKFONE),(LENGTH(trim(RKFONE))-3),4) RKMASK
FROM XRDK/CUSTOMERS

Result;


===

It doesn't exactly mask the field but it looks like it does;
Repeat is used to repeat the character 'X' for whatever the result of "field length -4" is.
|| is concat (join what's on the left to what's on the right)
SUBSTRING is looking for the last 4 digits of the field

Hope it helps,
Ryan.

Thank you frnd for your help