SORT-MERGE/XL allows you to sort and merge multiple files in a single operation. This is done by placing the names of the files to be sorted and then merged within parentheses when entering the >INPUT command. Below, the files EMPLOYEE (shown in the previous example) and NEWHIRES (shown below) are sorted by job title and then merged into the file COMPANY in a single operation. The file NEWHIRES contains the following four records:
1 2 3 4
123456789012345678901234567890123456789012345
1 CARLSON PETER BUYER 8043
2 ADAMS JERROLD INSPECTOR 8044
3 MATHEWS EDDY PLANNER 8045
4 CLARK STEVE ASSEMBLER 8046
|
To sort, and then merge, these two files in a single operation, enter the following commands:
:SORT
HP32214A.01.00 SORT/3000 WED, JUN 3, 1987, 9:11 AM
© HEWLETT-PACKARD CO. 1986
>INPUT (EMPLOYEE, NEWHIRES)
>OUTPUT COMPANY
>KEY 23, 19
>END
>PURGE OLDOUTPUT FILE COMPANY.GROUP.ACCOUNT? Y
<<The SORT Statistics Appear Here>>
:EDITOR
HP32201A.07.17 EDIT/3000 WED, JUN 3, 1987, 9:12 AM
© HEWLETT-PACKARD CO. 1985
/TEXT COMPANY
FILE UNNUMBERED
/LIST ALL
1 2 3 4
123456789012345678901234567890123456789012345
1 ANDERSON MARY ACCOUNTANT 6345
2 CLARK STEVE ASSEMBLER 8046
3 CARLSON PETER BUYER 8043
4 SMITH HOWARD DESIGNER 6794
5 LANGE ROBERT ENGINEER 3235
6 ZIMMER ANDREW ENGINEER 5739
7 ADAMS JERROLD INSPECTOR 8044
8 MATHEWS EDDY PLANNER 8045
9 ANDERSON CHARLES PRESIDENT 0247
10 JOHNSON FRANCES RECEPTIONIST 7943
11 ANDERSON CHARLES SALES REP 3456
12 TAYLOR HEATHER SECRETARY 7272
13 FISHER TOM SHIPPING CLERK 7309
14 CARLSON ROBERTA TREASURER 3586
|
The two files (EMPLOYEE and NEWHIRES) are sorted and merged in the same SORT/XL operation and the output file COMPANY is created.