SQL: Updating Name without special characters.

 %Execute()
 UPDATE %Table(LAC_AB540_STG) B
  SET B.FIRST_NAME = (
 SELECT TRANSLATE(A.FIRST_NAME
 ,'éêëèÉÈÊËðÐâàáãæàåÅÀÁÂÃÆäÄïîìíÌÍÎÏôòóõøÒÓÔÕØöÖûùúÙÚÛÜüñÑÇçýÿÝþÞ'
 ,'eeeeEEEEDDaaaaaaaAAAAAAaAiiiiIIIIoooooOOOOOoOuuuUUUUunNCcyyYTt')
  FROM PS_LAC_NAMES A
 WHERE A.EMPLID = B.EMPLID
   AND A.NAME_TYPE = 'PRI'
   AND A.EFF_STATUS = 'A'
   AND A.EFFDT = (
 SELECT MAX(A_ED.EFFDT)
  FROM PS_LAC_NAMES A_ED
 WHERE A.EMPLID = A_ED.EMPLID
   AND A.NAME_TYPE = A_ED.NAME_TYPE
   AND A_ED.EFFDT <=%CurrentDateIn ))
 WHERE B.PROCESS_INSTANCE = %ProcessInstance
   AND EXISTS (
 SELECT 1
  FROM PS_LAC_NAMES A
 WHERE A.EMPLID = B.EMPLID
   AND A.NAME_TYPE = 'PRI'
   AND A.EFF_STATUS = 'A'
   AND A.EFFDT = (
 SELECT MAX(A_ED.EFFDT)
  FROM PS_LAC_NAMES A_ED
 WHERE A.EMPLID = A_ED.EMPLID
   AND A.NAME_TYPE = A_ED.NAME_TYPE
   AND A_ED.EFFDT <=%CurrentDateIn ));