- Log on to the iSeries and get to a command line.
- Start SQL with STRSQL.
- Find all orphaned Employee Extension records with:
SELECT EMPNJF FROM AMFLIBy/EMPMSX WHERE EMPNJF NOT IN (SELECT EMPNO FROM AMFLIBy/EMPMAS)
- Issue delete statements for each number found:
DELETE FROM AMFLIBy/EMPMSX WHERE EMPNJF = [Number found in previous statement]
- Exit SQL with the F3 key. Issue a 2 to not save.
- Log off the iSeries.
Modified on: Mon, 29 Jan, 2018 at 8:49 AM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.