...
This procedure CANNOT be used on TC internal userid’s
/* CHANGE USERID PROCDURES - SETUP “OLD” AND “DESIRED NEW” USERID’S ON Z980 */
UPDATE Z980_TERM_CONVERSION
SET FROM_TXT = 'old-userid',
TO_TXT = 'new-userid'
WHERE TERM_TYPE_CD = 'USERCHANGE';
COMMIT ;
/* ensure Ensure desired new userid is not in use */
...