FIRST ENHANCEMENT:

In future enhancements a record extract ‘key’ should be saved for matching against separate extracts.


SECOND ENHANCEMENT:

Please allow for one or more UNION ALL statements in the SQL part of the DB2 or Legacy extract:

Notice the parenthesis needed at the beginning.

(SELECT * FROM XXXXX.TAXXXXXX
WHERE FIELD_1 = 1
fetch first 5000 rows only)
UNION ALL
(SELECT * FROM XXXXX.TAXXXXXX
WHERE FIELD_1 = 2
fetch first 5000 rows only)