CREATE MASK snippet

[rubensdemelo]

Description of the feature or enhancement

I would like to see a snippet/code completion to CREATE MASK:

CREATE MASK SSN_MASK ON EMPLOYEE
    FOR COLUMN SSN RETURN
      CASE 
           WHEN (1 = 1) 
            THEN 'XXX-XX-' || SUBSTR(SSN,8,4)
           ELSE NULL
      END
    ENABLE;

COMMIT;

ALTER TABLE EMPLOYEE 
    ACTIVATE COLUMN ACCESS CONTROL;

COMMIT;

SELECT 'XXX-XX-' || SUBSTR(SSN,8,4) FROM EMPLOYEE 
    WHERE EMPNO = 123456;

https://www.ibm.com/docs/en/db2-for-zos/12?topic=statements-create-mask

[katsoohoo]

Thanks for your suggestion @rubensdemelo. We'll consider this in a future release.