HP 3000 Manuals HP 3000 Manuals
Sorting and Merging Multiple Files
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
(c) 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
(c) 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.