MFX can directly retrieve data from a DB2 database based on a user-provided query. An SQL SELECT statement is used to specify the criteria of the request. The query of the DB2 database replaces MFX's SORTIN or E15 processing. SORT or COPY functions, but not MERGE, can be used with DB2 queries. All MFX features performed after E15 processing are available for use with the DB2 query facility. Refer to The Flow of the Sort for a summary of MFX's features and flow of control during processing.
The MFX DB2 Query facility improves performance over DB2’s DSNTIAUL program by allowing DB2 data to be passed directly into a SORT or COPY operation, without the use of setup steps or the need for user-written E15 exits.