SORT-MERGE/XL General User's Guide (32650-90883)

Chapter 4 53
Using MERGE/XL Interactively
Sorting the File
Sorting the File
Before the newly created file NEWHIRES can be merged with any other files it must first be
sorted. Sort the file NEWHIRES using the same >KEY command used in the file EMPLOYEE
(>KEY 1, 11; 12, 11; 23, 19):
:SORT
HP32214A.01.00 SORT/3000 WED, JUN 3, 1987, 11:35 AM
© HEWLETT-PACKARD CO. 1986
>INPUT NEWHIRES
>OUTPUT NEWHIRES
>KEY 1, 11; 12, 11; 23, 19
>END
PURGE OLD OUTPUT FILE NEWHIRES.GROUP.ACCOUNT ? Y
<<The SORT Statistics Appear Here>>
:EDITOR
HP32201A.07.17 EDIT/3000 WED, JUN 3, 1987, 11:40 AM
© HEWLETT-PACKARD CO. 1985
/TEXT NEWHIRES
FILE UNNUMBERED
/LIST ALL
1 2 3 4
123456789012345678901234567890123456789012345
1 ADAMS JERROLD INSPECTOR 8044
2 CARLSON PETER BUYER 8043
3 CLARK STEVE ASSEMBLER 8046
4 MATHEWS EDDY PLANNER 8045
This chapter contains examples of merging this file with the file EMPLOYEE in ways useful
to a Personnel Department.
In the above example, after you entered the >END command, the system displayed the
message:
PURGE OLD OUTPUT FILE NEWHIRES.GROUP.ACCOUNT ? Y
This message tells you that a file named NEWHIRES already exists in your group and
account, and asks if you want the old version purged. If you reply YES, the old version of
NEWHIRES is purged and a new version containing the information from this sort is created.
If you reply NO, you are prompted for a new file name. You then enter a new, unique file
name; and you have two files, the original file named NEWHIRES and the newly created file.