MATCH Processing Without a Common High-Order Sort Field

If there are no common high-order sort fields, a match is performed on a record-by-record basis.


Top of page

Example: Merging Without a Common High-Order Sort Field

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