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

32 Chapter3

Using SORT/XL Interactively

Single Key Alphabetical Sorting

A basic sorting operation can arrange, or order, data in an ascending alphabetical

sequence, using a single key data item. The following example shows the commands you

use to direct SORT/XL to order the last names in the ﬁle EMPLOYEE into a standard

alphabetical order. Following the SORT/XL commands, you will see the steps for entering

the EDIT/V subsystem to display the results of the sort process. As mentioned above, the

output ﬁle containing the sorted data is named COMPANY.

:SORT

HP32214A.01.00 SORT/3000 WED, JUN 3, 1987, 8:20 AM

>INPUT EMPLOYEE

>OUTPUT COMPANY

>KEY 1, 11

>END

<<The SORT Statistics Appear Here>>

:EDITOR

HP32201A.07.17 EDIT/3000 WED, JUN 3, 1987, 8:21 AM

/TEXT COMPANY

FILE UNNUMBERED

/ LIST ALL

1 2 3 4

1234567890123456789012345678901234567890123456789

1 ANDERSON MARY ACCOUNTANT 6345

2 ANDERSON CHARLES SALES REP 3456

3 ANDERSON CHARLES PRESIDENT 0247

4 CARLSON ROBERTA TREASURER 3586

5 FISHER TOM SHIPPING CLERK 7309

6 JOHNSON FRANCES RECEPTIONIST 7943

7 LANGE ROBERT ENGINEER 3235

8 SMITH HOWARD DESIGNER 6794

9 TAYLOR HEATHER SECRETARY 7272

10 ZIMMER ANDREW ENGINEER 5739

END OF SUBSYSTEM