DEFINE FILE EMPDATA
NEWID/A11=EDIT (ID,'999-99-9999');
END
DEFINE FILE SALHIST
NEWID/A11=EDIT (ID,'999-99-9999');
CSAL/D12.2M=OLDSALARY;
END
TABLE FILE EMPDATA
HEADING
"EMPLOYEE SALARIES"
" "
PRINT CSAL
BY NEWID
WHERE CSAL GT 65000
MORE
FILE SALHIST
WHERE OLDSALARY GT 65000
END
Syntax: How to Concatenate Data Sources
The MORE phrase, which is accessible within the TABLE and MATCH commands,
specifies how to concatenate data from sources with dissimilar Master Files.
{TABLE|MATCH} FILE file1 main request MORE FILE file2 subrequest MORE FILE file3 subrequest MORE . . . {END|RUN}