If there are no common high-order sort fields, a match is performed on a record-by-record basis.
The following request has no common sort fields:
MATCH FILE EMPLOYEE PRINT LN FN DPT BY EID RUN FILE EMPDATA PRINT LN FN DEPT BY PIN AFTER MATCH HOLD OLD-OR-NEW END TABLE FILE HOLD PRINT * ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, SIZE=9,$ ENDSTYLE END
The retrieved records from the two data sources are written to the HOLD file. No values are compared. The output is shown in the following image.
Information Builders |