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

48 Chapter3
Using SORT/XL Interactively
Using File Equations in SORT/XL
Using File Equations in SORT/XL
An alternative method for designating the input and output files is to establish file
equations at the MPE XL colon prompt (:) before you access the SORT/XL subsystem.
Then when you access SORT/XL, you need only enter the >KEY and >END commands, as
follows:
:FILE INPUT=EMPLOYEE
:FILE OUTPUT=COMPANY
:SORT
HP32214A.01.00 SORT/3000 WED, JUN 3, 1987, 11:15 AM
© HEWLETT-PACKARD CO. 1986
>KEY 1, 11; 12, 11
>END
<<The SORT Statistics Appear Here>>
:EDITOR
HP32201A.07.17 EDIT/3000 WED, JUN 3, 1987, 11:18 AM
© HEWLETT-PACKARD CO. 1985
/TEXT COMPANY
FILE UNNUMBERED
/LIST ALL
1 2 3 4
123456789012345678901234567890123456789012345
1 ANDERSON CHARLES PRESIDENT 0247
2 ANDERSON CHARLES SALES REP 3456
3 ANDERSON MARY ACCOUNTANT 6345
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